I am trying to achieve Quarter on Quarter calculation; I don’t have a date field, as such the granularity is year and quarter. I need to calculate following:
Q1FY12/Q1YF11 as Q1FY12
Q2FY12/Q2YF11 as Q2FY12
Q3FY12/Q3YF11 as Q3FY12
Q4FY12/Q4YF11 as Q4FY12
FY12/FY11 as FY12 (Full Year View)
Q1FY13/Q1YF12 as Q1FY13
Q2FY13/Q1YF12 as Q2FY13…and so on.
Its a pivot table with dimensions Quarter and Year with the following expression, I am trying to use the following formula, Before is working fine with 1 dimension FQY (Fiscal Quarter) as soon as ‘m adding full year (Fiscal Year) to get the sales for total year its not giving me any results per se.
Need your help to find a solution here…please refer the attached QV for more details.