Last 12 Months Sales

[manideep78]

Dear Community,

I have a date column which is in number format. I want to display the sales of last 12 months including this month. April-15, Mar-15,.., May-14.

My dimension would be say 'Item'.

Note: I want that date expression (which filters the particular month like april-15, mar-15,.....) to be in a variable so that, I can easily reduce one month by subtracting any value from that variable in the set expression. so that I need not write the date expression again and again in all the 12 months sales expressions.

Please suggest any better way of doing it.

Thanks in advance

Regards,

Manideep

[manideep78]

without any selection I want 12 months from 2015 to 2014 thought the max year is 2022. if current year is 2016 then 2016 to 2016 like that. the default year should be current year.

[#3]

hi,

then you fix the date in variable.

Regards

Vimlesh