rolling last 5 five quarter

[#1]

2012-2013 Q3            YEAR SELECTION BASED

2012-2013 Q2

2012-2013 Q1

2011-2012 Q4

2011-2012 Q3

[#2]

Hi Ram,

For current selections:

=Right('$(Selected_Max_Year )',2)&'`'&'Q'&'$(Selected_Max_Quarter)'&'W'&'$(Selected_Max_Week)'

and for previous quarters: for week 52 means Q4

Fiscal_Year={$(=IF(('$(Selected_Max_Week)'-52) > 0 ,'$(Selected_Max_Year )','$(Selected_Max_Year )'-1))},

Fiscal_Quarter={$(=IF(('$(Selected_Max_Week)'-52) > 0 ,'$(Selected_Max_Quarter)'-4,IF('$(Selected_Max_Quarter)'-4 <=0 ,'$(Selected_Max_Quarter)'-4+4)))},
Fiscal_Week={"<=$(=IF(('$(Selected_Max_Week)'-52) > 0 ,'$(Selected_Max_Week)'-52,'$(Selected_Max_Week)'-52+52))"}
>}

this if or week39 and Q3

Fiscal_Year={$(=IF(('$(Selected_Max_Week)'-39) > 0 ,'$(Selected_Max_Year )','$(Selected_Max_Year )'-1))},

Fiscal_Quarter={$(=IF(('$(Selected_Max_Week)'-39) > 0 ,'$(Selected_Max_Quarter)'-3,IF('$(Selected_Max_Quarter)'-3 <=0 ,'$(Selected_Max_Quarter)'-3+4)))},
Fiscal_Week={"<=$(=IF(('$(Selected_Max_Week)'-39) > 0 ,'$(Selected_Max_Week)'-39,'$(Selected_Max_Week)'-39+52))"}
>}

this is for week 26,Q2

Fiscal_Year={$(=IF(('$(Selected_Max_Week)'-26) > 0 ,'$(Selected_Max_Year )','$(Selected_Max_Year )'-1))},

Fiscal_Quarter={$(=IF(('$(Selected_Max_Week)'-26) > 0 ,'$(Selected_Max_Quarter)'-2,IF('$(Selected_Max_Quarter)'-2 <=0 ,'$(Selected_Max_Quarter)'-2+4)))},
Fiscal_Week={"<=$(=IF(('$(Selected_Max_Week)'-26) > 0 ,'$(Selected_Max_Week)'-26,'$(Selected_Max_Week)'-26+52))"}

this is for week13 ,Q1

Fiscal_Year={$(=IF(('$(Selected_Max_Week)'-13) > 0 ,'$(Selected_Max_Year )','$(Selected_Max_Year )'-1))},

Fiscal_Quarter={$(=IF(('$(Selected_Max_Week)'-13) > 0 ,'$(Selected_Max_Quarter)'-1,IF('$(Selected_Max_Quarter)'-1 <=0 ,'$(Selected_Max_Quarter)'-1+4)))},
Fiscal_Week={"<=$(=IF(('$(Selected_Max_Week)'-13) > 0 ,'$(Selected_Max_Week)'-13,'$(Selected_Max_Week)'-13+52))"}
>}

hope you will get understand and at least it will give idea..

Thanks,

Chandra

>}