1 Reply Latest reply: Nov 10, 2015 7:06 AM by Stefan Wühl RSS

    Working with cumulative for Pareto

      My data is has following cols

       

      Country, State, Period(in mm/dd/yyyy format), Qty, Year

      A, A1, 1/1/2015, 10, 2015

      A, A2, 1/1/2015, 20, 2015

      A, A1, 2/1/2015, 25, 2015

      A, A1, 1/1/2014, 15, 2014

      A, A1, 2/1/2014, 10, 2014

      B, B1, 3/1/2015, 30, 2015

       

      I want to achieve the following output

       

      Year     Country     Sum(Qty) (for the Year) (in descending order)     Cum Qty          Cumulative % (at  Year level)

      2015                   A           10+20+25=55                                          55                  =55/(55+30)

      2015                   B            30                                                         55+30=85        =85/(55+30)

      2014                   A            15+10=25                                               25                 =25/(25)

       

      Any help much appreciated.

       

      Currently I achieve the above checking the Relative and Full Accumulation options.