| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting multiple columns (fields) in a 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
| Max Number Fields/Columns In Pivot Table | New Users to Excel | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| Pivot Table with Multiple Row Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
