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

    Rolling 12 months in bar chart

    Steve Free

      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