Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table field selection order
Hi,
Using Excel 2007 For some reason my Pivot Table Field List selection under "Choose fields to add to report:" is sorted in ascending order and not in the order they appear in the data. This means that the data dates are sorted by month by year and not by year by month. e.g. Sum of 1 Apr 2009 Sum of 1 Apr 2010 Sum of 1 Apr 2011 Sum of 1 Aug 2009 Sum of 1 Aug 2010 Sum of 1 Aug 2011 Sum of 1 Dec 2009 Sum of 1 Dec 2010 etc instead of Sum of 1 Apr 2009 Sum of 1 May 2009 Sum of 1 Jun 2009 etc. This makes selecting contiguous months REALLY tedious!! What have I done?? Any suggestions appreciated! Regards, Bony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Synchronize the Pivot table page field selection in 2 tables? | Excel Worksheet Functions | |||
Pivot Table field list order | Excel Discussion (Misc queries) | |||
Pivot table row field order | Excel Discussion (Misc queries) | |||
Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
Pivot Table Ascending Order of Row Field | Excel Discussion (Misc queries) |