Cube Views Column & Row time intersection
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...
Forum Discussion
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.
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