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
|