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

Hi, try grouping your fields by year and by month



Bony Pony;375897 Wrote:
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. :)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105187

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.

"Pecoflyer" wrote:


Hi, try grouping your fields by year and by month



Bony Pony;375897 Wrote:
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. :)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105187

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

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" wrote:

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

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

Bony Pony;376061 Wrote:
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.

"Pecoflyer" wrote:


Hi, try grouping your fields by year and by month



Bony Pony;375897 Wrote:
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. :)


--
Pecoflyer

Cheers -

------------------------------------------------------------------------
Pecoflyer's Profile: 'The Code Cage Forums - View Profile: Pecoflyer'
(http://www.thecodecage.com/forumz/me...pecoflyer.html)
View this thread: 'Pivot Table field selection order - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...d.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


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105187

Thanks again :)

"Herbert Seidenberg" wrote:

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