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:
Recipe for an ABC Analysis
Recipe for a Pareto Analysis – Revisited
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
See below the link:
Its not about the answer, rather it’s about the question…
Here you go!
Qlik Community Tip: Marking Replies as Correct or Helpful
Andy
