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

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

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