Cumulative Total On Ranking

John Hughes · 2025-06-12T18:30:21+00:00

There was an error rendering this rich post.

In an object, how do I do a cumulative total on a ranking column? I'm trying to do an 80/20 analysis and to grab the top 80% of an entity but each row is just their % to total, not a cumulative %.

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @John Hughes ,

if it is something like this you'd like to achieve

you can build up the layout like this

Remember these two points

Each ranking function will refer to the directly preceding block, always.
An 80/90/5 ranking requires the data to be sorted.

Feel free to let me know if you have any more questions.

Best,
Helmut

All comments

Helmut Heimann

Hi @John Hughes ,

could you please share screenshots of the layout and the current/desired outcome?

Best,
Helmut

Helmut Heimann

Hi @John Hughes ,

if it is something like this you'd like to achieve

you can build up the layout like this

Remember these two points

Each ranking function will refer to the directly preceding block, always.
An 80/90/5 ranking requires the data to be sorted.

Feel free to let me know if you have any more questions.

Best,
Helmut

John Hughes

@Helmut Heimann, yes this is exactly what I'm looking for. How did you come up with block D "Cumulated Vertical %" or is that a separate data cube?

John Hughes

Never mind, I found it. Thanks @Helmut Heimann!