Multi-column sort issue in Pivot Table
 

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

Multi-column sort issue in Pivot Table
 

Hi Mark

You need to set the Sort on ID fieldAscending Using Fieldselect from
dropdownFruit


--
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

Multi-column sort issue in Pivot Table
 

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" wrote:

Hi Mark

You need to set the Sort on ID fieldAscending Using Fieldselect from
dropdownFruit


--
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

Multi-column sort issue in Pivot Table
 

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