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

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

Example <<<<<<<<<

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

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

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

"John87111" wrote:

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

Example <<<<<<<<<

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