Charting Rolling Average Totals

[#1]

Hi,

I have a table where I am calculating the rolling average of a data series with each collum at different roll lengths (Collumn 1 is 1 second, 2 is 2 second etc.)

I have the values for all the averages in the total using the max of expression total mode in the total row of the straight table. What I want to do is plot these maximum values in a line chart accross the roll length to show decrease/increase as the time period increases. I've tried using variables but had no joy. I have put the expression I'm using and an image of the table below.

Any ideas would be greatly appreciated!!!

rangesum

(above([Power per revolution W],0,1  )) / 1

rangesum

(above([Power per revolution W],0,2  )) / 2

etc.

Cheers

Matt