One method would be to use the INDEX() Table Calculation to create a nested rank for each provider, then use it as a filter.
Attached is an example using superstore that's as close as I could get it to your screenshot.
Based on the screenshot, the compute using set up for the index would be something like this:
At the level: Povider
Restarting Every: Product Line
Sort Order: Custom Sort
NonPar Allowed Sum
For more information on adjusting the addressing and partitioning of table calculations, please see: Table Calculation Functions
Hope this helps!
Top5Example.twbx 1.2 MB
Both answers are correct. Thank you so very much.