Getting Sum of Line Item's Previous Values without Time Dimension
I'm trying to find a way for the following challenge:
1. There is a standard business case model for a supermarket that includes such lines as CAPEX, Revenue, Expenses, etc. The standard business case model doesn't have a specific launch month or data of launch for a supermarket as this is a business case for a TYPICAL supermarket. This means that this business case model doesn't have specific months like Jan 21, Feb 21, etc. but rather Month 1, Month 2, etc.
2. In this model there are several financial metrics that require to use previous values of same LI that is calculated. For example, to calculate cumulative FCF to find the breakeven point
Below you can find the current realization which I've made but now I'm struggling with the problem of not having Time dimension.
Can anyone suggest a workaround while we all wait for the implementation of this idea? https://community.anaplan.com/t5/Idea-Exchange/PREVIOUSITEM-formula-which-is-like-PREVIOUS-but-references-a/idi-p/46481
Thank you in advance,