Classify SKU by sales contributions

[PhuongTran52]

Hi the community,

Thank you for helping me. I have a list of many SKUs with sales volumes and I want to rank the sales volume by SKUs from highest to lowest and categorise the SKUs into 3 class:

• Class A: top SKUs that contributes to 80% of my total sales
• Class B: top SKUs that contributes to the next 10& of my total sales
• Class C: remaining SKUs, that contributes to the last 10% of my total sales

Thank you in advance for helping me

[Luke_C · Accepted solution]

Hi @PhuongTran52 

You could try something like this: 

1. Sort by sales
2. Get the total sales
3. Get the % of total sales
4. Compute the running total of the %s
5. Use an if statement to classify based on the running total.

Hopefully this gets you on the right path.