I am using Excel 2007. I have built a pivot table. I have a field in the Report Filter section of the pivot. There are about 95 values in this drop-down. Problem: The list isn't sorted in alphabetical order. Or rather, for the most part it is, but not entirely. How can I force this Report Filter drop-down to sort values alphabetically.
Bookmarks