Rolling Quarter to Quarter

[#1]

Now I'm a little bit of different requirement. I've the year(2011,2012 etc.) and its relevant quarters(1,2,3,4) is present in the raw data and I'm trying to calculate Quarter Year on Quater Year (QYoQY) calculation where if I select the year as 2013 Q2 then it should show me the data from 2013 Q1 to 2012 Q2.

Any Suggestion for this scenario.....

Thanks In advance.

Vignesh kumar,

[senpradip007]

vignesh Kumar wrote:

Now I'm a little bit of different requirement. I've the year(2011,2012 etc.) and its relevant quarters(1,2,3,4) is present in the raw data and I'm trying to calculate Quarter Year on Quater Year (QYoQY) calculation where if I select the year as 2013 Q2 then it should show me the data from 2013 Q1 to 2012 Q2.

Do you want data  from 2013 Q1 to 2012 Q2 or 2013 Q1 to 2013 Q2 if you select 2013 Q2?

[#3]

If i select 2013 Q2 i need to display data for  previous 4 Quarters like 2013 Q1, 2012 Q4 , 2012 Q3, 2012 Q2. Kindly give some ideas to resolve it.

Thanks in advance.

Regards,

Vignesh Kumar

[senpradip007]

You can try like:

Sum({<Date={">=$(=Date(AddYears(QuarterStart( Max(Date)), -1),'DD/MM/YYYY')) <=$(=Date(Max(Date)),'DD/MM/YYYY')"}>} [Your Field])