cumulative figures on chart not as expected

[#1]

HI

I'm trying to produce a line graph to display a year on year trend for the cumulative sales

the data comes in looking like the attached excel file 'imported data'

the members are summed by month and I can produce a quantity of members by month/ year

If the chart is a straight / pivot table I can also produce the cumulative totals

using

rangesum(Above(Column(1),0,RowNo()))

or similar

however when i then try and look at it in chart form even though im using the same template as the graph above it cumulates all the years on top of one another. I can seperate the year out by selecting the years from a list box but ideally being able to see them all together would be more beneficial.

Is there a simple way of doing this.

Sorry but cant send actual data or script , hopefully the description above is adequete

[#2]

Hi Lee

Not sure to understand what you want  but if the goal is to show a graph like above (year and month dimensions)  with cumulated values  it exists a property where you just check "cumulate" in expression tab

best regards

Chris

[Gysbert_Wassenaar · Accepted solution]

Try setting the accumulation option for your expression, --sum(Members)?--, to Full Accumulation.

[#4]

slaps head , oh of course.. many thanks