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.
| A | B | C | D | |
| Header 1 | Year | Vintage | Revenue | Cumulative Revenue | Equation |
|---|
| 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 |
