Hi Mark

Sorry, I misinterpreted your layout.
If you want to have ID as the first Row Item, followed by Fruit (which then
displays as 2 columns ID Fruit) you will have to set both fields to
Manual sorting.
Then, hover over 3 until you see a 4 way arrow, left click and drag to the
top.
Hover over 2 and drag to Bottom

--
Regards
Roger Govier

"Mark b." wrote in message
...
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