Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Friend
Please use Following Expression,
Sum({<Date={">=$(=Monthstart(max(Date)-11))<=$(=max(Date))"},Year=,Month=>} Sales)
Regards
Vikas
Hi
Giving blank, can you qvw file for this
Thanks for your help
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