Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT Table Sorting - PLEASE Help!!!!!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
Sorting / Pivot Table | New Users to Excel | |||
Pivot Table Sorting | Excel Discussion (Misc queries) | |||
pivot table sorting | Excel Worksheet Functions | |||
Need help sorting pivot table | Excel Discussion (Misc queries) |