Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 425
Default Sort pivot table field (droplist) by month or original data

I have a pivot table of which I updated with additional info...
WHen I updated it, the months (starting with June, July, August, Sept,
etc) were rearranged and is now out of order on my drop down list
(filter) on the pivot table. Is there any way to get this back to the
same order that the original data is in, or correct subsequential
month order?

Reads Should Read
June June
July July
Sept August
August Sept
October October
December December
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default Sort pivot table field (droplist) by month or original data

Excel 2007
Pivot Table will not sort correctly
if some months are fully spelled out (December)
and others are not (Sept).
Once all the months are in the same format
as in the Built-in Lists, sorting should be automatic.
For other data, sorting the field will also sort the drop down list.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Sort Field Help pdek Excel Discussion (Misc queries) 3 December 4th 07 03:13 PM
Convert date field to month in Pivot table MESTRELLA29 Excel Discussion (Misc queries) 9 May 23rd 07 02:50 PM
Sort Pivot Table using hidden data field goofy11 Excel Discussion (Misc queries) 4 February 3rd 06 08:13 PM
Calculated Pivot table field on YTD £(subract Mar-feb)=month John Excel Worksheet Functions 1 January 6th 06 12:02 AM
How do I restore original Pivot Table data? Andrew C Excel Discussion (Misc queries) 5 January 5th 06 06:21 AM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"