Multi-column Sort in Pivot table

M

Mark b.

Using Excel 2009:

I'm trying to resolve how to sort by the second row field in my Pivot table.

In the field properties, the first field (ID) is set to Sort Manually, the
second field (Fruit) is set to Sort Ascending. I keep getting the result
below:

ID Fruit Value
1 Bananas 100
2 Cherries 50
3 Apples 75

What I really want is to sort by the Fruit field without rearranging the
fields (the ID is a serial number not a rank) to get the result below:

ID Fruit Value
3 Apples 75
1 Bananas 100
2 Cherries 50

Thanks,
Mark
Thanks,
Mark
 

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

Multi-column sort issue in Pivot Table 3
Multi column sort issue within Pivot table 0
Sorting multiple columns (fields) in a pivot table 1
Problem with multiple sorting of fields in Pivot table 0
Issue with Multiple sort fields in pivot table 0
I don't know which formula to use? 4
Need running percentage in pivot table 1
ASAP bout pivot table 1

Top