Pouplating year value without Time dimension
Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my
Mapping Year (line item) format is Year.
CHRT** and YR** are my two dimensions used here.
It may be helpful to use cumulate function along with line items.
Please see this anapedia in detail.
And here is an example of Year adding.
I hope this could help you.
▼See CUMULATE('Number_1', FALSE, CHRT)
If you don't set the current period, you may have to choose 'initial_year' manually.
▼Here is the result.
Thank you Taichi, this really helped.