Is there a way to sort the choices presented in a filter in a pivot table.
Refreshing the data (after sorting the data) does not alter the sequence of
options presented in the filter in the pivot table. The sort function is
also not available when you click on the filter itself in the pivot table.