Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Rahul,
Try this expression
Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Today(), -11))<=$(=Today())’}>} Sales )
Hope it will helpful!!