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

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

"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