Hi,

Double-click the Name field button and in the Pivot Table Field dialog box
click Advanced. Choose Descending or Ascending depending on which way you
want the Count to be sorted. Then pick the Count of Names from the Using
field list and click OK.

This will cause the count colum to be in order and the name field to stay in
the default sort order of ascending.
--
Cheers,
Shane Devenshire


"JPreeshl" wrote:

I have a pivot table with names then the count of those names. I want to sort
by the count first then the names. I can only sort by 1 or the other. When I
sort the count column the name column does not sort correctly.
name count
jeff 3
sam 3
adam 3
joe 2
I would like adam to be the first name in the sort. How do I sort both
columns?