Multi-column sort issue in 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?

 

[Roger Govier]

Hi Mark

You need to set the Sort on ID field>Ascending> Using Field>select from
dropdown>Fruit

 

[Mark b.]

Roger, thanks, but you're suggestion didn't work as the choices from the
dropdown are ID and Total Quantity.

ID and Fruit are row fields. Total Quantity is the summary Data field. so
actual table is better represented as listed below:

ID Fruit Total Quantity
1 Bananas 300
2 Cherries 200
3 Apples 100

Any other thoughts?

--
Thanks,
Mark

Hi Mark

You need to set the Sort on ID field>Ascending> Using Field>select from
dropdown>Fruit

 

[Roger Govier]

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