Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
Date gaps in chart after pivotTable | Charts and Charting in Excel | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Sorting in PivotTable | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) |