| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
ok thanks for that.
"Debra Dalgleish" wrote: You can do that kind of sort in Excel 2007, but not in earlier versions. Scott R wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PIVOT Table Sorting - PLEASE Help!!!!! | Excel Discussion (Misc queries) | |||
| Pivot Table Sorting | Excel Worksheet Functions | |||
| Sorting / Pivot Table | New Users to Excel | |||
| Pivot Table Sorting | Excel Discussion (Misc queries) | |||
| Need help sorting pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
