Sorting by Date in Pivot Tables

J

JuliaW

I have a worksheet I would like to make a pivot table from. My problem
is that when I do it, the months and years don't appear in calendar
order but rather alphabetical order (i.e., April comes first, January
is further down). How can I format this to have the pivot table show
January of 2002, rest of 2002 and then start January 2003?
 
B

Bernie Deitrick

Julia,

If you entered the dates as string values, then Excel will sort them as strings. If you enter the dates as dates, then Excel will
sort by date.

Format the cell with January 2002 as Number. If it stays January 2002, then your 'dates' are actually strings. When it changes to
37257, then you have actual dates, and Excel will work as you expect.

HTH,
Bernie
Excel MVP
 
Y

you suck

if yoiu change the format to yy-mm-dd or yy-mm then it should sort by year
then month
 

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

Dealing with a Pivot Table (when I don't want to) 0
SUM & OFFSET & PIVOT TABLE?? 0
Pivot table 0
Duff Date Text 3
Using the "group and show detail" in a pivot table 3
Pivottabel / running totals / year-to-date 1
Grouping daily transactions by month (using pivot tables), acrossyears 1
pivot table missing rows? 0

Top