Do you have a calc that loads either charges or patients based on the parameter selection, and then displays that calc?
If not, that's something to consider.
Then if you have that, just rank that calc.
Yes, I have the parameter called Placeholder 1 Selector and I have a calcuation Placeholder 1:
CASE [Placeholder 1 Selector]
WHEN "Patient Count" THEN [Patient_Count]
WHEN "Total Charges" THEN SUM([Charge Amount])
And this is on my Columns Shelf and Doctor name on the Rows.
How do I rank that calc?
At a minimum you could click on the [Doctor] pill on ROWS and select Sort, and choose Placeholder 1 to sort on.
You could also create a calc like this:
RANK( SUM([Placeholder 1]), 'desc')
that would give you a 1-through-N value for SUM([Placeholder 1]) that you can use wherever you need rankings. (For example, selecting the top-10 based on the selected measure.)