Multi-column sort issue in Pivot Table

  • Thread starter Thread starter Mark b.
  • Start date Start date
M

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?
 
Hi Mark

You need to set the Sort on ID field>Ascending> Using Field>select from
dropdown>Fruit
 
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


Roger Govier said:
Hi Mark

You need to set the Sort on ID field>Ascending> Using Field>select from
dropdown>Fruit
Click to expand...
 
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
 
Back
Top