I am trying to build a waterfall chart and issue i am facing is on the End Total.
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.