Would it be possible to post some sample data with a workbook? I can think of a couple possible solutions, but it would be much easier if I had some sample data to work with.
1 of 1 people found this helpful
Something you could try is making a new calc for the values you want and then sorting by that. For example you could try:
IF [Term] = "Fall 2018"
THEN [Number of Records]
Then right click on the [Nations] pill and select "Sort". Use your new field to sort.
Thank you, Wesley. This was exactly what I needed.