Sort choices in filter in pivot table

B

Bob

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.
 
J

Jack GTA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Sort Order 1
date filter in a pivot table 1
Pivot Table Missing Filter Tab 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot Table (column/row) label cache reset 4
Value filter missing in pivot table 3
Pivot Table Report Filter Sorting 3
Pivot Table - Drop down choices 1

Top