software

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 quot;3/1/2006quot; 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!

Select a cell in the 3/1/2006 column
Click the Z-A button on the Excel toolbarMDW wrote:
gt; Say I've got a Pivot Table that looks like this:
gt;
gt; 1/1/2006 2/1/2006 3/1/2006
gt;
gt; Dave 10 5 4
gt; Sam 7 1
gt; George 9 9
gt;
gt; I'd like to be able to sort on the individual columns...for instance, to
gt; sort on the column quot;3/1/2006quot; from highest to lowest. The only sorting I can
gt; find would sort the the column order based on the dates, or the row order
gt; based on the names. But I need to sort the row order based on something else.
gt; How do I do that?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html