Does this look right?
If yes, then this is what I did:
1. Created a calculated field to compute the Sales % along item.
2. Created a calculated field to identify the item as essential or non-essential.
Hope this helps. Updated workbook is attached.
Fantastic! Looks like its definitely put me in the right direction, just have to apply it to the data we have. Brilliant - thank you!
You are welcome. Appreciate if you can close this thread.