Last 12 months Expression

[#1]

Hi All,

I have a date field as 2015-04-01 for every month. And also Year and Month field created from the Date field.

Now there is a need to display the sum(sales) for last 12 months. I am trying to create the expression to limit the months from last year present month to this year month(Today()) , but its not working.

It will be great if I can get some help.

[Anonymous]

Hi Rahul,

Try this expression

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>} Sales )

Hope it will helpful!!