Sort pivot table field (droplist) by month or original data


J.W. Aldridge

I have a pivot table of which I updated with additional info...
WHen I updated it, the months (starting with June, July, August, Sept,
etc) were rearranged and is now out of order on my drop down list
(filter) on the pivot table. Is there any way to get this back to the
same order that the original data is in, or correct subsequential
month order?

Reads Should Read
June June
July July
Sept August
August Sept
October October
December December

Herbert Seidenberg

Excel 2007
Pivot Table will not sort correctly
if some months are fully spelled out (December)
and others are not (Sept).
Once all the months are in the same format
as in the Built-in Lists, sorting should be automatic.
For other data, sorting the field will also sort the drop down list.

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