Cube Views Column & Row time intersection

[JenJessel]

I am trying to get prior year actuals in the same column as current year actuals.  The code i am using in the CV is above.  This result pulling back in YTD prior year but I want monthly value for prior year.  

[CarlosAlvear]

Hi Jen,

Try using ":V#MTD" to change the data to monthly to date.

Regards,

Carlos

[JenJessel]

Thanks Carlos.  This is closer.  It is giving me a monthly result, however it is pulling back Dec Prior year for each month.  I was trying to get prior year monthly results for each month.

[CarlosAlvear]

Hi Jen, you mean that for instance if you're in 2022M4 you want to see 2021M4? In that case you can try something like this: T#WFPrior12 (that means 12 periods prior the WF).

Good luck

Regards

[JenJessel]

Thanks Carlos.  We created a UD8 prioryearperiod dynamic calc which is working.