1 Reply Latest reply: Oct 13, 2015 4:23 AM by Manish Kachhia RSS

    Cummulative values on a line chart

    Andrew Thomas


      Hi

       

      I have a line chart that shows periodic values by year. The chart is calculating a variance % by period but what I need the chart to do is calculate the cummulative variance % each period. i.e bring forward the values from the previous period and recaclulate the total variance for the period

       

      I've attached my QVW and the line chart is on the metrics tab

       

       

      Any help would be appreciarted as I'm not sure if I need to do this in the load script or the chart properties

       

      Thanks