Hi,
as per attached example, I am trying to create a ABC ranking for the 80/20 pareto of our product sales.
How can I make it so that the ranking will only apply to visible products, so that when some are filtered, they are not calculated.
Also, how can we make it, so that the sales column can be sorted in any order (and not just cumulative). Basically, I want to be able to filter and sort - and the ranking will always show the ABC correctly, regardless.
Lastly, how to do this with only formulas!
Thanks for any support, as I've wasted hours trying to solve this without luck!
Bookmarks