Forum Discussion

JenJessel's avatar
JenJessel
New Contributor III
10 months 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
10 months 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
    10 months 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