Showing last 12 months data.

[kishorj1982]

Hi All,

PFA

Can you please suggest how to show last 12 months data

thanks

[arvind_patil]

Hi Kishor,

I think You require rolling 12 months data :

Please go thorough below thread.

12 month rolling data‌

max year rolling 12 months

Thanks,

Arvind Patil

[Anonymous]

use the function Today() --> Today() -12 and all this in a month function -- > month(Today() -12)

or

= {">=$(=Date(AddMonths(vMaxDate, -12), 'MMM-YYYY'))<=$(=Date(vMaxDate, 'MMM-YYYY'))"},

and vMaxDate = Tady()

another way more efficient and useful is to create in your script a calendar where you'll have for days, months, years, quarters and then use it as a dimension