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 ?
