 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Pivot 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 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:"  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hi > [quoted text clipped - 18 lines] > > John 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 > 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 [quoted text clipped - 23 lines] > > > > John 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 > 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 [quoted text clipped - 23 lines] > > > > John No prob, John. Glad you found the way to do it. I guess the pivot sorting feature was enhanced in xl2003. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Max > [quoted text clipped - 6 lines] > > Thanks for your help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.