MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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?

Posted by Mark W. on April 18, 2001 10:21 AM

What's the 1st column?

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?

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.

Posted by Holly on April 18, 2001 10:41 AM

So simple! Thank you so much for your help.