I have Query related to waterfall chart in Anaplan. I have a below modules with line items mentioned. Want to create water fall chart with Actual Contribution line item acting as a total in the Chart. Since Actual Contribution line item does not have simple sum of above line item. It doesn't allow it to act as total in Waterfall chart.
FYI, In Excel we can randomly select any row to act as total in Water fall chart.
Can any one help me on this.