Custom Sort Order For PivotTable

I am new to Pivot Tables and would like to have Oct, Nov and Dec of 2009 to appear before Jan 2010

The job started in Oct and I am tracking progress. Now it come after June 2010.

Re: Move Columns in Pivot Table.. Dec before Jan

Here is what I have:

DateProductUnits
10/1/2009 Apples 10
1010/15/2009 Peaches 20
11/1/2009 Apples 30
12/1/2009 Lemons 40
1/1/2010 Strawberries 60
1/15/2010 Watermelons 70

I group on date and I get Jan,Oct, Dec

I tried to upload this info in a spreadsheet but the upload fails

Re: Custom Sort Order For PivotTable

I found the answer.

Under group there is another selection..Year.. selecting both month and year puts the data in the correct format.

Thanks