Sorting multiple columns (fields) in a pivot table

[Mark b.]

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?

 

[Debra Dalgleish]

The second column will only automatically sort its items under each of
the first column items. So, all the fruit under ID 1 will sort
alphabetically, as will all the fruit under ID2, etc.

If you want the ID items in a different order, you can manually drag
each item to a different spot in the list. For example, click on the ID
3 cell, then drag its border till it's at the top of the list.