Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I searched and found a solution:
Aggr(RangeSum(Above(Sum(SALES),0,RowNo())),YEAR,QUARTER)
Who searches does not err