| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi column sort issue within Pivot table
I'm having issues with soreting 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 | |||
| Multi-column Sort in Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Data Column Sort Excel 2007 | Excel Discussion (Misc queries) | |||
| multiple column sort in a pivot table | Excel Discussion (Misc queries) | |||
| Multi core and pivot table woes | Excel Discussion (Misc queries) | |||
| Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
Linear Mode
