Rangesum with 2 dimensions in chart

[jarwitwicki]

hi,

I am looking for a solution

I have such sample data:

I made a chart with sums of cumulative function:

=RangeSum(Above(TOTAL Sum([SALES]), 0, RowNo(TOTAL)))

On the chart I have a sum for all the years and previous months and I want to sum up each year separately.

So, for example, for 2018 year (Q1,Q2,Q3) – RangeSum – (25,45,75) and for 2017 year (15,35,55,85) on chart,

can someone help me.

[jarwitwicki]

I searched and found a solution:

Aggr(RangeSum(Above(Sum(SALES),0,RowNo())),YEAR,QUARTER)

Who searches does not err