Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA
Can you please suggest how to show last 12 months data
thanks
Hi Kishor,
I think You require rolling 12 months data :
Please go thorough below thread.
Thanks,
Arvind Patil
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