How do I sort the the data within a Pivot table (not sum data)

G

Guest

Hi, I'm trying to sort the data within my pivot table. I have change the
sort flag, but it only sorts the total for the particular data element
(Retail has highest total & Entertainment is lowest), I also want to sort the
items within each element (Within retail Orange should be first, apple second
and Bannana third). How can I get it to do a sort within a sort?

Thanks! John

Retail 10,000
Apple 2,000
Bannana 1,000
Orange 7,000

Gasoline 9,000
Texaco 6,000
Mobil 1,000
Chevon 2,000

Entertainment 5,000
Movies 1,000
Golf 3,000
Bungee Jumping 1,000
 
G

Guest

Help from someone please...!!!!!

John87111 said:
Hi, I'm trying to sort the data within my pivot table. I have change the
sort flag, but it only sorts the total for the particular data element
(Retail has highest total & Entertainment is lowest), I also want to sort the
items within each element (Within retail Orange should be first, apple second
and Bannana third). How can I get it to do a sort within a sort?

Thanks! John


Retail 10,000
Apple 2,000
Bannana 1,000
Orange 7,000

Gasoline 9,000
Texaco 6,000
Mobil 1,000
Chevon 2,000

Entertainment 5,000
Movies 1,000
Golf 3,000
Bungee Jumping 1,000
Click to expand...
 

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

PIVOT Table Sorting - PLEASE Help!!!!! 4
How to sort data in data area in a pivot table 1
How do I sort pivot table data by subtotals? 2
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
How do I Use the MANUAL Sort Option in a Pivot Table? 1
How do i sort and count data into categories using a pivot table? 1
How do I get a Pivot Table to repeat the values in the columns? 4
Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA? 4

Top