Calculated Date Dimensions in a Pivot Table?

[aritting]

I would like to create a pivot table that has the current Year and the current and previous Quarter as calculated dimensions.

I've found that I can get current year by year(today()) expression butI'm not sure how to get the current and previous quarter.

[sunny_talwar]

May be like this:

If(Match(Year, Year(Today(), Year(Today()-1), Year) for Year Dimension

If((Date >= QuarterStart(Today()) and Date <=QuarterEnd(Today())) or (Date >= QuarterStart(AddYears(Today(), -1)) and Date <=QuarterEnd(AddYears(Today(), -1))), Quarter) for Quarter Dimesnion

Check the option on the Dimensions tab - > Suppress When Value Is Null for both the dimensions.

HTH

Best,

Sunny

[aritting]

I'm not following what is going on there.

[aritting]

I want to see a pivot table chart where the current year is the calculated dimension and the current and previous quarter

2015          Q1

                 Q2

[sunny_talwar · Accepted solution]

I thought you needed 2015 Q2 and 2014 Q2. For what you need, try this:

Two of your dimensions will be

If(Match(Year, Year(Today(), Year) for Year Dimension

If((Date >= AddMonths(QuarterStart(Today()), -3) and Date <=QuarterEnd(Today())), Quarter) for Quarter Dimesnion

[aritting]

=if(Match(Year, Year(Today())),Year)

[MarcoWedel]

Hi,

another solution could be:

hope this helps

regards

Marco