Sort choices in filter in pivot table
 

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.

Sort choices in filter in pivot table
 

Hi,
To fix the issue just remove the dimension currently used as a filter
completely from the pivot table, refresh the table and then put the dimension
back again. The members should now be back in Alphabetical order

"Bob" wrote:

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.