Calculated Dimension for YearQTR

[#1]

Hi All-hope someone can help me on this.I have a dimension called 'current YrQtr' which returns value 2012Q3 for Nov.I need a calculated dimension which should return current qtr along with three previous qtrs.

Final result should be

2012Q3,2012Q2,2012Q1 and 2011Q4.

Thanks-pooja

[MayilVahanan]

Hi

Due to have date field? if so,

Try like this

=sum({<Date = {'>=$(=Monthstart(AddMonths(today(),-12)))<=$(=Today())'}>}Sales)

Calculate last 12 month from today..

Hope it helps

[#3]

Thanks for your reply.Objective is to have a calculated dimension that can dispaly 4 qtrs(current qtr and 3 previous qtrs).I am not worried about expression.

[MayilVahanan]

HI

Use current YrQtr as dimension and then use the above epression. if you have datefield..

Can you post a sample file/