5 Replies Latest reply: Mar 12, 2013 4:34 AM by Sorcha Collins RSS

    How to stop two lines appearing on the one graph for the one calculation?



      I have a line chart with sales figures for the last twelve months, calculated on a rolling period.

      For example, we are now in March 2013 so the chart dates back to April 2012, and updates each month.



      I have one expression, the Actual figures for the last twelve months, which is made on a variable.


      The chart is now displaying two lines within the chart for the actual figure instead of one line.


      See Example below;


      Has anyone any idea how to fix this so that only one line appears?