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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Sort
Just some thoughts. I don't know about xl2000, but in my xl2003, I'd click on
the field in the ROW area. Then from the PivotTable dropdown (on the pivot toolbar), I'd select Sort and Top10. And in the ensuing dialog, I could select the Autosort option (say descending) and choose the field (from amongst those in DATA) from the dropdown under "Using field:" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Calder" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Sort
Thanks Max, but I think Exl2000 is slightly different.
I have noticed that even trying to sort the data on the pivot table itself does not work properly?....The raw data I am trying to sort is all formatted as text so I have no idea why it wont sort Thanks again "Max" wrote: Just some thoughts. I don't know about xl2000, but in my xl2003, I'd click on the field in the ROW area. Then from the PivotTable dropdown (on the pivot toolbar), I'd select Sort and Top10. And in the ensuing dialog, I could select the Autosort option (say descending) and choose the field (from amongst those in DATA) from the dropdown under "Using field:" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Calder" wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Sort
Max
I fixed the probelm. The column I was trying to sort was the 2nd column on the pivot table. I switched this column with column 1 and now it sorts ok. Its seems it only likes the data in the pivot table to be sorted by the 1st column of the table. Thanks for your help "Max" wrote: Just some thoughts. I don't know about xl2000, but in my xl2003, I'd click on the field in the ROW area. Then from the PivotTable dropdown (on the pivot toolbar), I'd select Sort and Top10. And in the ensuing dialog, I could select the Autosort option (say descending) and choose the field (from amongst those in DATA) from the dropdown under "Using field:" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Calder" wrote: 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Sort
No prob, John. Glad you found the way to do it. I guess the pivot sorting
feature was enhanced in xl2003. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John Calder" wrote in message ... Max I fixed the probelm. The column I was trying to sort was the 2nd column on the pivot table. I switched this column with column 1 and now it sorts ok. Its seems it only likes the data in the pivot table to be sorted by the 1st column of the table. Thanks for your help |
Reply |
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 |