When I am using the pivot table, the months are getting sorted alphabetically.
Can this be avoided?
Please help me sort this issue.
When I am using the pivot table, the months are getting sorted alphabetically.
Can this be avoided?
Please help me sort this issue.
maybe it will help a little: Excel Pivot Table Sorting
or
Go To > More Sort Options > Right Click ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically
Untick this option:
No it does not do the trick.
If your mionths are being sorted alpha, chances are they are not real dates, but text. Do a quick test with =isnumber(cell-with-date)....if the answer is FALSE, you have text and we will need to convert them
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try to mention the months in full name as January, February etc
then go to pivot table ->Sort -> More Sort Options -> More Options ->Untick Autosort ->First Key Sort order (Jan,feb,mar) -> ok
Hope this works
Regards,
Fareed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks