Pivot Table Sort Issue

G

Gene Moirao

Hi
Using Excel 2003 and the field Month (Jan....Dec), moved into the Row area.
Been working fine (special month sort order) for months. Now the months do
now sort "correctly" (Jan....Dec), but sorts Jan...Dec with May and Jun in
the last 2 positions. All other 10 months sort correctly.
?
thanks,
Gene:)
 
M

Max

Maybe its a data issue -- text dates/real dates ?
Check the recent data. Ensure all are real dates.
 

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

Sorting dates in the format Jan Feb Mar Apr ... ??? 4
Pivot Table - month groups 2
Pivot table 3
Sort by Month and Year 1
Pivot Table Sort 4
Countifs or a pivot 1
Filtering by Month 3
Search Columns for a word and stop 14

Top