| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Soret
Greetings,
Need help as I can't seem to get my pivot table to Sort. Want to sort by ascending or descending based on value in total column of data. I try the Pivot Table/Sort and Top 1 but only seems to give me option to sort the first column. Any help or direction is appreciated. Thank You! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Sort
On 2007 version, Right click on any of the value in the column that you want
to sort and hover on the sort option. There will be options to sort ascending/descending and other sort options. "Steve B" wrote: Greetings, Need help as I can't seem to get my pivot table to Sort. Want to sort by ascending or descending based on value in total column of data. I try the Pivot Table/Sort and Top 1 but only seems to give me option to sort the first column. Any help or direction is appreciated. Thank You! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Linear Mode
