| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Sort Issue
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:) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Sort Issue
Maybe its a data issue -- text dates/real dates ?
Check the recent data. Ensure all are real dates. -- Max Singapore --- "Gene Moirao" wrote: 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:) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One pivot table cannot overlap another pivot issue. | Excel Discussion (Misc queries) | |||
| Multi-column sort issue in Pivot Table | Excel Discussion (Misc queries) | |||
| Multi column sort issue within Pivot table | Excel Discussion (Misc queries) | |||
| Pivot table sum issue | Excel Discussion (Misc queries) | |||
| Pivot Table Issue | Excel Worksheet Functions | |||
Hybrid Mode
