Forum Discussion

cons1's avatar
cons1
New Contributor III
11 months ago

Show Quarter last month

Hi,

This is most likely basic but I cannot find a reference for this. 

I want to show the time Quarter in a cube view, but the name should be the last month of the quarter instead of Q1. Should be March 2023.

May I know how to do this?

Thank you in advance.

Cube View
  • db_pdx's avatar
    db_pdx
    11 months ago

    I'd probably keep the monthly time selection but override the view to QTD.

    With Time as the primary dimension selection, it would be: T#2023M3:V#QTD

    This should still display 'March 2023' but your data will be the full quarter.

  • CarlosAlvear's avatar
    CarlosAlvear
    Contributor
    11 months ago

    Hi Cons,

    It depends on how you define the time at the begginning (year, quarte, month...)

    Here you have some of the available options.

    If you start with the years as time, you can set it fixed as T#(your_year).M3, T#(your_year).M6, T#(your_year).M9, T#(your_year).M12

    If you have the quarter as time, you could set it as T#FirstPeriodInMonthPrior1(your_quarterTime) [not tested].

    Good luck

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    11 months ago

    I'd probably keep the monthly time selection but override the view to QTD.

    With Time as the primary dimension selection, it would be: T#2023M3:V#QTD

    This should still display 'March 2023' but your data will be the full quarter.