rolling 12 months

[Anonymous]

HI

I have date field with 3 years dates. But i need to get 12 months rolling.

How can we get 12 months rolling

can some one suggest on this

[vikasdesai]

Hello Friend

Please use Following Expression,

Sum({<Date={">=$(=Monthstart(max(Date)-11))<=$(=max(Date))"},Year=,Month=>} Sales)

Regards

Vikas

[Anonymous]

Hi

Giving blank, can you qvw file for this

Thanks for your help

[Anonymous]

Try this its work fine .

  I have removed only $ symbol before the Field [Month-Year]

IF((date(AddMonths(date(date(today(),'YYYYMMDD'),'MM-YYYY'),-11),'MM-YYYY'))<=date#(date(today(),'YYYYMMDD'),'MM-YYYY'),

[Month-Year])

Regards

Sahadev