Using rule to navigate a dimension

[lynnsong986]

Hello,

I have a rule like this:

[‘2020’,’number of customers at start of period’]=[‘2019-12’,’number of customers at end of period’];

And so on and so forth for all years

Where the time dimension is like this:
2019-01
2019-02
2019-03
.
.
.
2019-12
2019 (consolidated element)
2020-01
2020-02
.
.
.
2020-12
2020(consolidated)
Is there a generic function I can use so that I don’t need to hard code 2020 and 2019-12? I know I could add an attribute to consolidated years with that month and use attrs to pull it, is there a better way of doing this such that all C level cells in time dimension would be equal to the last child of the previous C level element?

Thanks

[Wim Gielis]

No, use a Text attribute for this.

[lynnsong986]

Great thanks for letting me know!