We are developing a module using a dummy time dimension as the planning needs to be done for a period of 3 months. So just to save the space instead of using Anaplan Time dimension we have created a list with a subset for three months to be used in planning.
Now we have few line items as below where we calculate the opening stock and the closing stock value.
Challenge I am facing is that the opening stock of the month June 21 should be the closing value of May 21, but as we are using a dummy dimension unable to use previous and any other system lookup because of circular reference.
Is there any solution fir the same or any other way to use 3 month dimension for planning without taking much space.
Expected Values are below
In Qtr also we need Opening Value as 100 and Closing as 110 in Q1.