Sorting on PivotTable

[Guest]

Say I've got a Pivot Table that looks like this:

1/1/2006 2/1/2006 3/1/2006

Dave 10 5 4
Sam 7 1
George 9 9

I'd like to be able to sort on the individual columns...for instance, to
sort on the column "3/1/2006" from highest to lowest. The only sorting I can
find would sort the the column order based on the dates, or the row order
based on the names. But I need to sort the row order based on something else.
How do I do that?

 

[Debra Dalgleish]

Select a cell in the 3/1/2006 column
Click the Z-A button on the Excel toolbar