Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hello,
What you need is ABC Analysis.
Have a look here:
Thank you so much Eliza ! Your reply with the 2 links/ blog given has helped me to understand/ solve my problem.
Take Care !
I am glad it did help you.
Would you mind closing this thread.
Have a nice day!
Errmmm..how am i suppose to close the thread ? I wish to remain the thread to help the others