View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MDW
 
Posts: n/a
Default 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!