Pivot Table field selection order

[Bony Pony]

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

 

[Pecoflyer]

Hi, try grouping your fields by year and by month

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

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so.

 

[Bony Pony]

Hi,
If you read the question you will see that the selection table is sorted not
the resulting table. Grouping works at a table level.

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
See comparison of the two types of PTs.
http://www.mediafire.com/file/yw4tjlmumzi/06_10_09.xlsx

 

[Bony Pony]

Hi Herbert,
Great solution! I was interested to know how you access the PT Wizard in
2007 ??

While looking for it, I found the answer tomy own question.

In PivotTable Tools Ribbon under the Options Tab in the PivotTable section
where the PivotTable name is there is an Options tab. Click this, select
Options and then the Display Tab. At the bottom is a Field List option that
sorts the Source Data as you like it.

Thanks for the steer though!! Good tip for the future!

Best regards,
Bony

 

[Herbert Seidenberg]

Excel 2007
ALT+D+P
or
Customize Quick Access Toolbar >
PivotTable and PivotChart Wizard

 

[Pecoflyer]

Hi,
If you read the question you will see that the selection table is
sorted not
the resulting table. Grouping works at a table level.


Forums' (http://www.thecodecage.com/forumz/showthread.php?t=105187)

I did read our question and probably misunderstood, which, I believe ,
is admissible.
Maybe it was poorly stated for my feeble mind

 

[Bony Pony]

Thanks again