I am need of some help again, this time regarding sorting, I am not sure if I am looking for nested or dynamic sorting help.
Attached is a table that displays the data we are trying to sort. I have also attached a tableau file, displaying the data.
I would like to find a way to sort by the count of a column pill group value, by largest to smallest.
This is a screenshot of the excel sort done to create the view we want, as seen on Sheet 2 in excel file.
Thank you in advance for your help.