Rank products by sales and then flag the products that contribute to 50% of sales

[Usamah22]

Hi,

i want to rank my products and then identify the ones that contribute to 50% of the total volume so i can make a flag column with "Key Line". the sales would change each month so the products could change. how can i do this? data is like below.

product	Sales
a	1
b	7
c	2
d	1
e	9

[Jonathan-Sherman]

Hi @Usamah22,

You might need to go into a little more detail about the "Key Line" flag. Do you want to flag the product up if its sales made more than 50% of total sales?

I've mocked up an example with your data (using the above methodology, with no product selling >= 50% sales all "Key Line Flag" = "No"

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Usamah22]

Sorry i didn't explain clearly. i want to highlight which are the products that really contribute to the total sales figure of 20. you can see below products a and b are the main drivers. i want to be able to highlight such products so we can easily see them.

product	Sales	% of Total	Key Line
a	8	40%	Key Line
b	7	35%	Key Line
c	2	10%
d	1	5%
e	2	10%
Total	20	100%

[Jonathan-Sherman]

Hi @Usamah22,

So what is it that defines a "Key Line"? Is it being in the top 2 percentage contributions or is it any products where contribution is greater than X for example?

Regards,

Jonathan

[Usamah22]

In reality i have to do this for 900+ products so the top 2 wouldn't work. The top n number of products that contribute to 50% of the volume would be key lines. does that make sense?

[Jonathan-Sherman · Accepted solution]

Hi @Usamah22,

You could use a running total:

If this solves your issue please mark the answer as correct, if not let me know! I've attached an updated workflow for you to download if needed.

Regards,

Jonathan