Waterfall chart 1 litem using different versions as starting point and increase/decrease
Can anyone advise if the below is possible to do with waterfall?
Taking Forecast total figure & clusters variance to end up to the Total Actuals
So as an example sales:
Total forecast: 100
Total actual: 110
I have actuals and variance to forecast as versions in Anaplan & sales is a line item. We have a hierarchy 1. total 2. cluster.
See picture how I structed the data source.
I wasn't sure if the total actual is needed or should the start & changes automatically sum up to it.
I'd appreciate any advice. thanks