Rank products by sales and then flag the products that contribute to 50% of sales
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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% |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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