## Waterfall Chart Issue

Certified Master Anaplanner

## Waterfall Chart Issue

Hi All,

I am trying to build a waterfall chart and issue i am facing is on the End Total.

Scenario -

Publish a waterfall chart of basis points value ( not absolute numbers ) or you can consider the percentage value.  We have a baseline and division wise input as basis point, we have show the movement across divisions and than the Final End total at all division.

We have Three Divisions - Division A , B and C and parent as All Division

Baseline - 50 bps

Division A -10 bps

Division B - 20 bps

Division C - 30 bps

End Total (All Division) - 80 bps ( Point here is that is not sum of base + division as it calculated value)

Now challenge i am facing is until i put a sum in end total i can't prepare a waterfall chart and if i sum it than it is now showing the correct value.

Need community inputs and suggestion for way around this.

Thanks,

Nakul

Thanks,
Nakul
5 REPLIES 5
Community Boss

that's how waterfall chart work, with line items, one being a sum of the rest.

You have to transpose your dimension values to line items to make it work

Nathan Rudman, Anaplan Model Builder
Certified Master Anaplanner

We have already transposed this from Dimension to Line item. Because we ca't show the movement in Dimension so we transposed this as Line Item.

Thanks,

Nakul

Thanks,
Nakul
Community Boss

ah I get it. the var of the division is not equal to the sum of the var of each division of course
which means this is not a waterfall chart.

I don't think you can fool the chart logic by hiding the value inside, it is checking that only a pure addition works

Nathan Rudman, Anaplan Model Builder
Certified Master Anaplanner

Got it. Just checking out if i can any way get some solution from someone who committed this to client. 😄

Thanks

Nakul

Thanks,
Nakul
Community Boss
haven't tried in NUX though it might be a bit different

Nathan Rudman, Anaplan Model Builder