Water fall model.

[Anonymous]

Hi All,

Need some help in the waterfall model.

Please find the attachment for what I have done,(Which is far away from the look of it.) Am unable to get the correct expression for the bar offset to make it look like one. As the values on the Y-axis may be varying, I can't go with a hard coded subtraction process mentioned in many blogs. Please help

[sunny_talwar · Accepted solution]

This?

Bar Offset expression

Pick(Dim, 0, Sum(TOTAL Budget) + RangeSum(Above((sum(actual)-sum(Budget)), 0, RowNo()-1)) - (sum(actual)-sum(Budget)), 0)

[Anonymous]

Thank you sunny.