2007 - Pivot Talbe: Sort Report Filter
I have a pivot table and have the date column in the Report Filter
section. When I click the drop-down the list is not sorted like it is in the data. Is there a way to do this? -- Jerry |
2007 - Pivot Talbe: Sort Report Filter
How are they sorted in the data area and how are they sorted in the report
filter? Note - if the dates are legal Excel dates they will be sorted correctly in the report filter, if they are not legal dates they will be in a different order depending on what you are calling dates. 1/1/2009 is a date March is not a date 2009 is not a date 1/1/2009 entered as text is not a date. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jerry" wrote: I have a pivot table and have the date column in the Report Filter section. When I click the drop-down the list is not sorted like it is in the data. Is there a way to do this? -- Jerry |
2007 - Pivot Talbe: Sort Report Filter
"Jerry" wrote:
I have a pivot table and have the date column in the Report Filter section. When I click the drop-down the list is not sorted like it is in the data. Is there a way to do this? On Jul 28, 1:52*pm, Shane Devenshire wrote: How are they sorted in the data area and how are they sorted in the report filter? Note - if the dates are legal Excel dates they will be sorted correctly in the report filter, if they are not legal dates they will be in a different order depending on what you are calling dates. 1/1/2009 is a date March is not a date 2009 is not a date 1/1/2009 entered as text is not a date. -- If this helps, please click the Yes button. They are sorted in ascending order and stored as legal Excel dates. In the report filter they are not sorted at all and I can not get them to sort. -- Jerry |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com