Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

sorting by date in a pivot table

Posted by Holly on April 18, 2001 10:15 AM
I have created a pivot table in which the 2nd and 3rd
columns are date fields. I would like all of the data
in the pivot table to sort by the date order of
column 2. Is there some trick?

Re: sorting by date in a pivot table

Posted by Mark W. on April 18, 2001 10:21 AM
What's the 1st column?


Re: sorting by date in a pivot table

Posted by Holly on April 18, 2001 10:25 AM
:It's the event (meeting name) and the pivot table
is sorting alphabetically according to the text in
this column.

What's the 1st column?


Re: sorting by date in a pivot table

Posted by Mark W. on April 18, 2001 10:27 AM
After using the Advanced Field option to turn on
AutoSort you'll need to make your date field
the 1st column; otherwise, you'll just sort dates
within each event.


Re: sorting by date in a pivot table

Posted by Holly on April 18, 2001 10:41 AM
So simple! Thank you so much for your help.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.