Sum in waterfall chart

[#1]

I'm trying to create a waterfall graph that accumulates a certain expression sorted descending. I'm using

=above(SUM(Expression)

in my Bar offset resulting in the correct waterfall graph but ruining my sort. For example:

1
2
5
4
3

Should result in a waterfall

5
4
3
2
1

[#2]

Added an example QVW to demonstrate the issue

Department	Value
Marketing	1
Finance	3
Sales	4
HR	2
Facilities	2

[brenner_martina]

Hi Anja,

I do not really understand, what's your problem. Do you want to change the sortorder? You can enter "order by expression" desc value or any other field.

[#4]

I want my waterfall graph to look like this (sorted by Y value ascending), but if you look at the attached QVW in my earlier post the sort is not giving me this result.

[sicilianif · Accepted solution]

Put this in your bar offset expression:

If(rowno()=1,0,rangesum (above(sum(Value),1,rowno()-1)))

Then change your sort to be by expression descending and use this:

Sum(Value)

Frank

[#6]

Perfect! Thanks Much

[#7]

Frank,

Many thanks for this tip, exactly what I was looking for (when using only one dimension)!

Kind regards,

Rich

[#8]

A quick question, managed to get the Waterfall chart to display correctly when using one dimension, and sorting by "expression", descending sum(Euros)

When I change the dimension (from "Class") to a calculated dimension:

=if(GetPossibleCount(Family)=1,Class,Family) ,and again sort by descending "sum(Euros)" the following graph is displayed (without displaying the largest values first 😞

Any ideas why the sort is now behaving differently, now a calculated dimension has been added?

Please advise,

Kind regards,

Rich

[#9]

Hello,

Thank you for your solution.

How to offset the Others bar ?

How do you do when you choose to limit the number of values of your dimension (by using the option "Max Visible Number") and you active the "Show Other" option in the Presentation tab ?

Philippe