2 Replies Latest reply: Aug 31, 2012 12:03 PM by Luca Rizziero RSS

    chart with running sum and %

    Luca Rizziero

      Hi,

      I have the following data

      Customer

      Month

      Qty

      A

      1

      2

      A

      2

      3

      A

      3

      4

      B

      1

      12

      B

      2

      13

      B

      3

      14

       

      I’d need to obtain a chart containing for each customer+month the % of the total qty in the year.

      For instance:

      Customer

      Month

      Running qty

      Total qty per Customer

      %

      A

      1

      2

      9

      22%

      A

      2

      5

      9

      56%

      A

      3

      9

      9

      100%

      B

      1

      12

      39

      31%

      B

      2

      25

      39

      64%

      B

      3

      29

      39

      100%

      the Line Chart will have x=month and y=customers with 2 lines representing the % column

       

      Thanks