Pivot table & Date orders
 

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

Pivot table & Date orders
 

Hi Jay

ToolsOptionsCustom Lists
Create a list starting Nov-07 through Oct-08 (or later)

Double click on the field in the PTAdvancedSortAscending

--
Regards
Roger Govier

"James8309" wrote in message
...
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

Pivot table & Date orders
 

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

Regards,
Fred.

"James8309" wrote in message
...
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