| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with Multiple sort fields in pivot table
I'm having issues with sorting by multiple columns within a pivot table.
Essentially the data is currently sorted as follows: ID Fruit 1 Bananas 2 Cherries 3 Apples I'd like it to sort by the second column without rearranging the column order: ID Fruit 3 Apples 1 Bananas 2 Cherries I have the ID column set to 'Manual' within the fields Autosort settings. The Fruit field is set to 'Ascending' Any thoughts on how to get the desired results? -- Thanks, Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Sort Issue | Excel Discussion (Misc queries) | |||
| Multi-column sort issue in Pivot Table | Excel Discussion (Misc queries) | |||
| Multi column sort issue within Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Heading Fields - case sensitivity issue | Excel Discussion (Misc queries) | |||
| changing sort for pivot table fields | Excel Programming | |||
Linear Mode
