How to sort multiple columns in Excel Pivot Table

[Nicoloid]

I am 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 would 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.

[Shurod]

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.

[AnitG]

If I understood the problem correctly, then the solution in my Excel 2000 version is as follow. First Highlight a cell in column 2002 in the pivot table. Second Data menu, Sort descending, or the corresponding button. Third Ready. First Highlight a cell in column in the pivot table.