5 Replies Latest reply: Oct 4, 2011 10:32 AM by Marc Livingston RSS

    Rolling 12 months in bar chart

      Hi - thanks in advance for any help.

       

      I have a bar chart which has this as the dimension:

       

      planmonth(date) - so displays Jan 2011 - Oct 2011 when 2011 is selected - fine.

       

      I have this as an expression:

       

      sum([Valued Plan])

       

      The chart works fine in that it shows the previous months in the year selected or all months/years if no date selected, but needs to go back further.

       

      Need this chart to always show the last 12 months - so as of now Oct 2011 back to Nov 2010

       

      When viewed in say March 2012 will show Mar 2012 back to Apr 2011

       

      Hope this makes sense, thanks again