Graph rolling 24 months

[vardhancse]

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.

[nagarjuna_kotha]

Hi Sasi,

Try this Expression:

=sum({<Date = {">=$(=MonthStart(Max( DateField), -24))<=$(=MonthEnd(Max( DateField)))"},YearField=,MonthField=>}Sale)

[nagarjuna_kotha]

PFA....

in that Appliccation If u select Year  and Month it will gives you 24 months data.

Regards,
Nagarjuna

[neha_sri]

Hi Sasi,

You can check here.

Rolling Month

Regards,

Neha