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
