Assumptions:
Retail, Gasoline, etc are in a field called 'Category'.
The next level is called 'Type'.

- Go to your pivot table.
- Right-click on 'Category'
- Select 'Field Settings'
- Select 'Advanced...'
- Select 'Descending'
- Select 'OK'
- Select 'OK'
- Right-click on 'Type'
- repeat above steps

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"John87111" wrote:

Hi, I'm trying to sort the data within my pivot table. I have changed the
sort flag, but it only sorts the summed totals for the particular data
element. Based on my following example I get sorted summed total, but not
within each data set.
(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 of what I'm getting <<<<<<<<<

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


Example of what I'd Like to Get <<<<<<<<<

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

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

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