Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan. In the photos the blue value is editable data while the black has formulas.
If anyone has ideas to tackle this issue or information on how to go about this, I would greatly appreciate.