Pivot Table Filters Not Sorting Values Alphabetically

[JADownie]

Hello -

I have a report with several pivot tables. Some of my filter lists sort alphabetically fine, but others that are longer lists sort 90% alphabetically, and the other 10% are at the bottom. Why is that happening? Has this ever happend to anyone else? Can I fix that? Thanks!

 

[Andrew Poulsom]

Try removing the field and adding it again.

 

[JADownie]

No such luck with that. It appears that any new data added to my data file after the pivots were originally created does not sort correctly.

And I really don't wnat to have to add the field to the Row Labels to sort because i have pivot charts below the table, and then that screws with my formatting

 

[Andrew Poulsom]

Did you refresh the pivot table between removing the field and adding it?

 

[JADownie]

Yes before and after...

 

[Andrew Poulsom]

Try moving the field to the row area and set to sort. Then move it back.

 

[Tahlor]

Try moving the field to the row area and set to sort. Then move it back.

^ This worked like a charm. Thanks!