Rolling Avg of 12 Months? Urgent

[#1]

How to Caluculate this ?

2012: Avg(12 month rollingavg) - 2011:  Avg(12 month rollingavg)...

[mangalsk]

Hello

Use following expression:

Sum({<CalDate={">$(=addyears(max(CalDate),-1))<=$(=max(CalDate))"},CalYear=,CalMonth=,CalQuarter=>}Sales)

Regards

[kiranmanoharrode]

Use following expression:

Avg({<CalDate={">$(=addyears(max(CalDate),-1))<=$(=max(CalDate))"},CalYear=,CalMonth=,CalQuarter=>}Sales)

[Gysbert_Wassenaar]

I don't understand what you're asking. Can you show us some sample data and an example of the calculation?