6 Replies Latest reply: Apr 25, 2017 4:53 AM by Andrew Whitfield RSS

    Customer Classification

    Fung Keat Lim

      Hi Gurus

       

      Cust 1

                      58,095.80

      Cust 2

                      54,890.00

      Cust 3

                      51,373.60

      Cust 4

                      45,079.00

      Cust 5

                      30,854.00

      Cust 6

                      30,541.40

      Cust 7

                      29,237.40

      Cust 8

                      28,668.20

      Cust 9

                      23,280.20

      Cust 10

                      21,113.30

       


      Base  on above raw data, how am I classify the customer class base on the below criteria

       

      Class A (yellow)= Total of customer x 20 %

      In the above, ie : 10 x 0.20 = First 2 records 

       

      Class B (Green) = Total of customer x 50 %

      In the above, ie : 10 x 0.50 = Subsequent 5 records

       

      Class C (grey)= Total of customer x 20 %

      In the above, ie : 10 x 0.20 = subsequesnt 2 records

       

      Class D (red)= Total of customer x 10 %

      In the above, ie : 10 x 0.10 = subsequesnt 1 records 

       

      I have made to understand by using Aggr can do that ? But how exactly ?