Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Here is the set of data I have, can please let me know how to create rolling 24 months data in a chart.
For eg. , the dashboard have June 2015 data, then in the bar trend I need to see from the Jul -13 to Jun- 15.
Hi Sasi,
Try this Expression:
=sum({<Date = {">=$(=MonthStart(Max( DateField), -24))<=$(=MonthEnd(Max( DateField)))"},YearField=,MonthField=>}Sale)
PFA....
in that Appliccation If u select Year and Month it will gives you 24 months data.
Regards,
Nagarjuna