Pivot table & Date orders

[James8309]

Hi everyone,

I have created a pivot table and one of the column has month and year
in "mmm-yy" format. Problem that I am getting is when I put that data
column into pivot "column" it doesn't spread in the correct order.

i.e. I have everymonth from last november till this year november
(Nov-07 ~ Nov-08) Instead of ordering it in this manner (Nov-07,
Dec-07, Jan-08,.....Nov-08) it is ordering as alphabetical.
(Jan-07,Jan-08,...)

How do I set this orders correctly in my pivot table?


Thank you for your help in advance


Regards,



Jay

 

[Roger Govier]

Hi Jay

Tools>Options>Custom Lists
Create a list starting Nov-07 through Oct-08 (or later)

Double click on the field in the PT>Advanced>Sort>Ascending

 

[Fred Smith]

Change your dates to yymm format. Then it will always sort correctly.

Regards,
Fred.