0 Replies Latest reply: Jun 24, 2013 10:35 AM by Simon Koenen RSS

    Rolling month within chart

    Simon Koenen

      Hello together,

       

      I am trying to create a rolling months chart showing the biggest as well as the smalles value.

       

      Rolling months means that we have a date and value range from May 2011 to April 2013.

       

      Period YearValue12 mr valueExample
      May-1183.1

      Jun-1152.1

      Jul-1151.6

      Aug-1161.7

      Sep-1154.6

      Oct-1166.1

      Nov-1145.6

      Dec-119

      Jan-1273.1

      Feb-1236.7

      Mar-1276

      Apr-1277.1

      May-1248.2651.8=SUM(May 11 - Apr 12)
      Jun-1276.5676.2=SUM(Jun 11 - Jul 12)
      Jul-1270.6695.2=SUM(Jul 11 - Aug 13)
      Aug-1213.3646.8"
      Sep-1272.1664.3"
      Oct-1214.3612.5"
      Nov-1259.3626.2"
      Dec-1264.8682"
      Jan-1337.2646.1"
      Feb-136.5615.9"
      Mar-1394.8634.7"
      Apr-134.7562.3=SUM(May 12 - Apr 13)

       

      My problem is now, how to set up a chart showing the the values in column 3 from May 2012 to April 2013.

       

      I have set up this expression:

       

      =SUM({<

                [Measures (Key)]={'Operating Profit (EBIT)'},

                [Version single (Key)]={'Actual'},

                Period

      >}Values)/1000000

       

      including the function "Accumulation for 12 steps back".

       

      To this point all existing Period Year entries are shown within the chart.

       

      To get rid of this I have set a start and end value within the axes tab (Scale).

       

      This seems to be fine as long as I use only line charts and no bar charts.

       

      Furthermore I would like to identify the highest and smallest value.

       

      Normally I would use the rank function to identify it but it could be possible, that rank=1 is located in the results I have supressed by setting a min/max scalling within the axes tab of the chart properties.

       

      And now I have no ideas left how to set up this chart in a useful way.

       

      Any suggestions?