Forum Discussion

JenJessel's avatar
JenJessel
New Contributor III
2 years ago

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...
Cube View
JenJessel's avatar
JenJessel
New Contributor III
2 years ago

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's avatar
    CarlosAlvear
    Contributor II
    2 years ago

    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