Rolling Twelve Months

[darrellbutler]

Hi, I want to plot a graph with month year as a dimension. The expression I want to show is the last twelve months sales. So for Jan2011 I want to show sales from Feb 2010 to Jan 2011 and so on.

Any pointers gratefully received !

[#2]

Easiest way is to make it a calculated dimension

if(month_year>=time_period_begin and month_year<=time_period_end,month_year)

Then select

Supress when value is null

[SunilChauhan]

see the attached file

hope this helps