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

    cummulative sales set analysis

    james eckstein

      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.

       

       

       

       

       

       

       

      ABCD
      Header 1YearVintageRevenueCumulative RevenueEquation
      12012

      2012

      1

      1

      C1

      22013201234C1+C2
      32013201355C3
      420142012711

      C1+C2+C4

      5201420131116C3+C5

      6

      2014201444C6
      7201520121728C1+C2+C4+C7
      820152013723C3+C5+C8
      9201520142024C6+C9
      102015201599C10