Issue on 12 months rolling....

[chinnu123]

Hi Team,

I am facing an issue on 12 months rolling data in Barchart

My scenario is

for example this is June 2016 so then the data must be shown from July 2015 to June 2016

                              July 2016 so then the data must be shown from august 2015 to July 2016

The data is related to Incidents and the fields are Submit month and Incidents ''

please can any one help on this..

Thanks,

Bhargav.

[vikramv]

Try this in your expression...

Sum($<Datefield = {">=$(=Date(AddMonths(Date(Today(),'YYYY-MM'), -11), 'YYYY-MM'))<=$(=Date(AddMonths(Date(Today(),'YYYY-MM'), 1), 'YYYY-MM'))"}>} Sales)