Classify SKU by sales contributions

Question

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 Answer

Hi @PhuongTran52

You could try something like this:

* Sort by sales
* Get the total sales
* Get the % of total sales
* Compute the running total of the %s
* Use an if statement to classify based on the running total.

Hopefully this gets you on the right path.