Check out this link...

http://www.contextures.com/xlPivot04.html
--
HTH...

Jim Thomlinson


"davidsokay" wrote:

Most of my numeric items appear in the drop down filter box in order. . I
know all these are numeric and I even tried to move it down to within the
pivot table report and got same problem. In excel 2007, I cannot figure out
how to ensure the drop down is in alphabetical order. This is a productivity
killer when looking for certain items. Any ideas?