Master Calendar Issue - how to include quarter-year

[#1]

Hello to all,

I want to develop a quarter rolling chart.

I already have a QuarterID field in my master calendar, which gives me a way to perform the set analysis for the chart.

Below, my master calendar:

The problem is that I don't have a field to use such as a 'Quarter-Year' to use as my dimension for the chart.

Using the field QuarterID as a dimension, I have the information I need, but not in a 'friendly user way'.

I need a field that says 'Q4-2015' in the place of '12' in the chart above.

How can I create a field like this in my master calendar?

Thanks for your support!!

[sunny_talwar]

Create it like this may be:

Dual('Q' & Ceil(Month(Temp_Date)/3) & '-' & Year(Temp_Date), QuarterStart(Temp_Date)) as QuarterYear

[Gysbert_Wassenaar]

Or create your QuarterID this way: Dual(Quarter & '-' & Year, Autonumber(Quarter & Year,'QuarterID')) as QuarterID

[#4]

Sunny,

Thanks for the support. I used the expression below to solve my issue, based on your and Gysbert answer.

Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3)

as [Quarter - Year]

Kind regards,

Marco

[#5]

Gysbert,

Thanks for the support. I used the expression below to solve my issue, based on your and Sunny answer.

Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3)

as [Quarter - Year]

Kind regards,

Marco