Waterfall Chart

[#1]

Hello, I'm trying to create income-outcome waterfall chart and i need some help.

I have 1 dimension: (headlines) and 1 expression: Sum (Amount).

And my chart look like this:

I have tried to put expression in the Bar Offset setting, like this:

if ([Exec P&L Heading]<>'incomes', fabs(RangeSum(Above(sum(Amount)),0,RowNo()))-fabs(sum(Amount)), 0)

The blue bar is "incomes" and should start from 0 offset.

But it's not working like it should be, only the red is right, as you can see the green is not touching the bottom of the red

Any help would be appreciated.

[Gysbert_Wassenaar]

Try: if ([Exec P&L Heading]<>'incomes', fabs(RangeSum(Above(sum(Amount)),1,RowNo()))-fabs(sum(Amount)), 0). The 1 instead of the 0 will prevent using the Amount of the current row in the calculation of the offset too. You want only the sum of all the previous values.