Sorting on PivotTable
 

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?
--
Hmm...they have the Internet on COMPUTERS now!

Sorting on PivotTable
 

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


MDW wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html