2007 - Pivot Talbe: Sort Report Filter

J

Jerry

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?
 
S

Shane Devenshire

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.
 
J

Jerry

Jerry said:
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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Pivot Table - Sort Report Filter Values 3
Pivot Table Report Filter Sorting 3
Pivot Table Sort Order 1
PIVOT - Reference a cell outside the table for report filtering 2
pivot tables 4
date filter in a pivot table 1
Sort choices in filter in pivot table 1
pivot table rolling 12 month filter? 1

Top