Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
I'm not following what is going on there.
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
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
=if(Match(Year, Year(Today())),Year)
Hi,
another solution could be:
hope this helps
regards
Marco