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.

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

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.

cons1Author

Thank you db_pdx, it worked.

Sign up