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 value for prior year.  

Cube View
  • CarlosAlvear's avatar
    CarlosAlvear
    Contributor
    10 months ago

    Hi Jen,

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

    Regards,

    Carlos

  • 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

  • JenJessel's avatar
    JenJessel
    New Contributor III
    10 months ago

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