Thread: how do I control the sort order of a filter in a pivot table?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Grizz Grizz is offline
external usenet poster
  
Posts: 3
Default how do I control the sort order of a filter in a pivot table?
I have a large dataset that I am running a pivot table on...the dataset
contains 300 customer names. I use customer name as a filter. In the filter
drop down, the first half of the list is in alphabetical order that ends in a
(blank) then the second half of the filter list is randomly sorted customer
names. Makes it hard to find what I need. Anyone have any ideas?
Reply With QuoteReply With Quote