Hi, I'm trying to display the sellers reponsible for the top n percent of total sales. I've copied sample data below. Ideally I'll have a slicer where I can drag the slider from 0 to 100 and be able to show all of the sellers that are responsible for the top 20% (for example) of sales. All of the solutions I've found use rankx and show me the top 20% of sellers (so if I have 100 sellers it will give me the top 20% of sellers). But if the top 2 sellers account for 20% of the sales, I only want to see those sellers. Thanks in advance for your help!
Solved! Go to Solution.
Thanks for your quick response! Unfortunately, what I'm actually looking for is to see the top % and not the sellers with over a certain % of sales. So when the slicer is on 80%, I should see only the sellers who are in the top 80% of sales (Sellers 1, 5, 3, 7)
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.