1 Reply Latest reply: Aug 30, 2018 6:39 AM by Jarosław Witwicki RSS

    Rangesum with 2 dimensions in chart

    Jarosław Witwicki

      hi,

      I am looking for a solution

      I have such sample data:

      1.jpg

      I made a chart with sums of cumulative function:

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

      2.jpg

      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.