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
|