Skip to main content
J
JenJessel
February 19, 2024

Cube Views Column & Row time intersection

  • February 19, 2024
  • 3 replies
  • 0 views

JenJessel_0-1708315744335.png

JenJessel_0-1708315823688.png

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.  

3 replies

C
CarlosAlvear
February 19, 2024

Hi Jen,

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

Regards,

Carlos

J
JenJesselAuthor
February 19, 2024

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.

C
CarlosAlvear
February 19, 2024

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

J
JenJesselAuthor
February 20, 2024

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

Terms & ConditionsAccessibility statement