Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Sort
Hi
I run WinXP with Excel2000 I have a table with about 70 lines of data. I have created a pivot table for the data (only 2 data columns and a total column) I would like to have the 2nd column in the pivot table sorted. I right click on the 2nd column header of the pivot table and select "field settings" I then select the "advanced" tab I click the Auto Sort option to ascending However, it does not sort the data. I have tried it descending and it is the same result What am I doing wrong? Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort top 50 in Pivot table | Excel Discussion (Misc queries) | |||
sort of pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Sort | Excel Discussion (Misc queries) | |||
Pivot Sort ??? | Excel Worksheet Functions | |||
Sort in Pivot Table | Excel Worksheet Functions |