Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- Column 2 sort
How can I sort a Pivot Table by the 2nd (or any other) column? I've selected
a cell and hit the A-Z Z-A Sort button, but it only works on column 1. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- Column 2 sort
Right click on the column and select Field Settings | Advanced to access the
sort options... -- HTH... Jim Thomlinson "srpd" wrote: How can I sort a Pivot Table by the 2nd (or any other) column? I've selected a cell and hit the A-Z Z-A Sort button, but it only works on column 1. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- Column 2 sort
Difficult to answer without knowing the structure of your underlying data and
what, exactly, is in the Pivot Table but try this: if the second column reads, for example, South, North, East, West (going down the column) just type in East where South is and see what happens. If my comments have helped please hit Yes. "srpd" wrote: How can I sort a Pivot Table by the 2nd (or any other) column? I've selected a cell and hit the A-Z Z-A Sort button, but it only works on column 1. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- Column 2 sort
I'm in Excel 2007. Right clicking on Field Settings brings up
Subtotals&Filters and Layout&Print but not an Advanced option. Is there another way to get there? Is this an add-in or permission based? Thanks for your help. "Jim Thomlinson" wrote: Right click on the column and select Field Settings | Advanced to access the sort options... -- HTH... Jim Thomlinson "srpd" wrote: How can I sort a Pivot Table by the 2nd (or any other) column? I've selected a cell and hit the A-Z Z-A Sort button, but it only works on column 1. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-column sort issue in Pivot Table | Excel Discussion (Misc queries) | |||
Multi column sort issue within Pivot table | Excel Discussion (Misc queries) | |||
Multi-column Sort in Pivot table | Excel Discussion (Misc queries) | |||
multiple column sort in a pivot table | Excel Discussion (Misc queries) | |||
Sort a Column of Dates in Pivot Table | Excel Worksheet Functions |