| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting a Pivot Table Column that is not the first column...
Is there a way that I can sort by a column in a Pivot Table that is
not the first column? The sort option works only for the first option and does not work when I try to sort by any other column. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting a Pivot Table Column that is not the first column...
You can sort the second column, but it will only sort within each group.
For example, if the first column is Region, and the second column is City, you can sort the Cities within each region. The region order won't be affected by the City sort. wrote: Is there a way that I can sort by a column in a Pivot Table that is not the first column? The sort option works only for the first option and does not work when I try to sort by any other column. Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table, How to add 1 column | Charts and Charting in Excel | |||
| Can a column be % of another column in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - how do I add a column? | Excel Worksheet Functions | |||
| "Cumulative" column based on a pivot table sum column? | Excel Worksheet Functions | |||
| Sorting data in a table by the header of a column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
