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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Lookup within a range of values 1
How to sort data in data area in a pivot table 1
Sorting data in Pivot Tables 2
How do I sort pivot table data by subtotals? 2
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Lookup a value within a range 5
How do I Use the MANUAL Sort Option in a Pivot Table? 1

Back
Top