Forum Discussion

cons1's avatar
cons1
New Contributor III
12 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 b...
Cube View
  • db_pdx's avatar
    db_pdx
    12 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.

db_pdx's avatar
db_pdx
Valued Contributor

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.

cons1's avatar
cons1
New Contributor III
12 months ago

Thank you db_pdx, it worked.