Forum Discussion
JanD
4 years agoFrequent Visitor
Waterfall with Opening balance
Hi there, I am seeking help regarding horizonal waterfal (bridge). On the x - axis there should be time hierarchy consisting of year,quarter, month and day. The starting point should be th...
JanD
4 years agoFrequent Visitor
Thanks amitchandak , but I am not looking for a cumulative calculation only.
It is true, it should start with cumulative summary of all previous amounts, but all days visible in in chart should show the exact amount of the current day, not cumulative value.
The closing amount should be however again cumulative total of all previous values.
Here is the link to PBI model.
https://drive.google.com/file/d/1GmRMFmcbzPBN_mNS3kxCx4z5utqoe38i/view?usp=sharing
Thank you again!