Sort a Column of Dates in Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are using Excel 2002.
We have created a Pivot that contains a column with dates: 9/21/05.
When the Pivot Table is created, it groups by a field name called Defect
Description but it willnot Sort the by Dates. We have tried using "Data",
"Sort", but it won't work.
We found info on the Knowlegde Base about manually setting the AutoSort
field but we can't make it work. We have even sorted the original data
worksheet but when the Pivot Table generates, the dates are "scrambled" out
of order.
Any ideas?
I hope someone can help us! Thanks.
Linny
 
Linny,

Rt-click on the column heading of the row field, select "Field Settings", then click "Advanced" and
change the Autosort options from manual to Axcending (or descending).

HTH,
Bernie
MS Excel MVP
 
Thanks for the information. I believe we have already tried this but we'll
give it another try!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table sorts date as Alpha, not as Date 6
Sorting the pivot table field list 4
grouping dates in a pivot table 1
Pivot Item Displaying Incorrect Value? 1
grouping dates in pivot table: calculated field? 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Sorting 2 data columns in Pivot Table 2
Pivot Table Sorting 1

Back
Top