2 Replies Latest reply: Oct 3, 2016 12:37 PM by Sunny Talwar

# cummulative sales set analysis

I have a table that includes Range A1:C10.

Year and vintage are dimensions and Revenue is an expression

I need to create set analysis to make the cumulative Sales column. The cumulative sales should be the sales for that specific vintage by each report year. For example Cumulative Revenue for

Year 2015 Vintage 2012

Should equal:

Revenue from Year 2012 vintage 2012

+

Revenue from Year 2013 vintage 2012

+

Revenue from Year 2014 vintage 2012

+

Revenue from Year 2012 vintage 2012

I included the equations that create the cumulative sales column.

Header 1 Year Vintage Revenue Cumulative Revenue Equation A B C D 1 2012 2012 1 1 C1 2 2013 2012 3 4 C1+C2 3 2013 2013 5 5 C3 4 2014 2012 7 11 C1+C2+C4 5 2014 2013 11 16 C3+C5 6 2014 2014 4 4 C6 7 2015 2012 17 28 C1+C2+C4+C7 8 2015 2013 7 23 C3+C5+C8 9 2015 2014 20 24 C6+C9 10 2015 2015 9 9 C10
• ###### Re: cummulative sales set analysis

May be like this:

Aggr(RangeSum(Above(Sum(Revenue), 0, RowNo())), Vintage, Year)