2 Replies Latest reply on Oct 15, 2015 2:17 AM by Abhishikt Dawson

Compare same quarter of 2 different years using a parameter

I have 2 years of data, FY14 and FY15 which are divided by quarter all namely FY14 Q1, FY14 Q2.... FY15 Q4. Can I create a parameter with quarter names and create a calculated field which would help me compare same quarters of 2 years, for example, If I have selected "FY15 Q1" in the parameter, then I should be able to compare FY14 Q1 and FY15 Q1.I have 2 years of data, FY14 and FY15 which are divided by quarter all namely FY14 Q1, FY14 Q2.... FY15 Q4. Can I create a parameter with quarter names and create a calculated field which would help me compare same quarters of 2 years, for example, If I have selected "FY15 Q1" in the parameter, then I should be able to compare FY14 Q1 and FY15 Q1.

• 1. Re: Compare same quarter of 2 different years using a parameter

Hi,

you can create a calculated field and use it to filter.

workbook attached.

Calculated field:

//only show the same quarter

right([Select a QR],2) = right([Quarter],2)

and

//show last year

int(mid([Quarter],3,2))

>=

(int(mid([Select a QR],3,2)) -1)

and

//show this year

int(mid([Quarter],3,2))

<=

int(mid([Select a QR],3,2))

• 2. Re: Compare same quarter of 2 different years using a parameter

That worked perfect!!! Thank you Americo.

Regards,

Abhishikt