Pivot Table Sort

M

Mark Smith

In a Pivot Table how do I sort by the sub-totals created by the pivot table



fruit Name
Apple Granny Smith
Apple Golden Delicious
orange Spanish
Orange OutSpan
Apple Grany Smith


-----------------------------------------------------

Pivot table would read

Fruit Name Totals
---------------------------------------------
Apple Grany smith 2
Golden Delicious 1
---------------------------------------------
Apple Total 3
---------------------------------------------
Orange OutSpan 1
Spanish 1
---------------------------------------------
Orange Total 2


How do i sort by Subtotals
Help Please
 

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

ASAP bout pivot table 1
Need running percentage in pivot table 1
how to count the number of times text occurs based on condition 3
Unable to identify appropriate formula for very simple scenario 2
HDI: Show Value as 'Percentage of' Grouped Column in Pivot 2
Lookup 5
Min-Max question 6
Problem with multiple sorting of fields in Pivot table 0

Top