Problem with multiple sorting of fields in Pivot table

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting multiple columns (fields) in a pivot table 1
Multi-column sort issue in Pivot Table 3
Multi column sort issue within Pivot table 0
Multi-column Sort in Pivot table 0
Issue with Multiple sort fields in pivot table 0
ASAP bout pivot table 1
How to ignore a column of numbers in Grand Total for rows 1
Inventory numbers - Consecutive, but out of sequence 4

Top