Pivot Table sort
 

Hi,
I am trying to create a pivot table of of some small data and when it is
created it unsorts the dates. In my data sheet i have it as January 2008,
February 2008,March 2008 etc yet my columns in the pivot are not in that
order....how can i place them in the correct order?

Pivot Table sort
 

Use a helper col to convert the text dates to real dates,
eg: In B2, copied down: = -- A2
where A2 down contains the text dates

Then pivot using col B instead of col A,
and it'll sort correctly in chrono order
(you can format it as date to taste)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:67
xdemechanik
---
"acss" wrote:
I am trying to create a pivot table of of some small data and when it is
created it unsorts the dates. In my data sheet i have it as January 2008,
February 2008,March 2008 etc yet my columns in the pivot are not in that
order....how can i place them in the correct order?

Pivot Table sort
 

You did not mention your version.

In XL2003

Simply click on a date and use the sort icon from the standard toolbar.

OR

1) Right-click on the date field heading
2) Click "Field settings"
3) Click "Advanced..."
4) Choose "Ascending" or "Descending" and check your date field shows in the
"Using field" list box before pressing OK.

IF DATA ARE NOT IN DATE FORMAT, the result will be sorted alphabetically. If
so, this MAY help

http://office.microsoft.com/en-us/ex...165021033.aspx
--
Steve

"acss" wrote in message
...
Hi,
I am trying to create a pivot table of of some small data and when it is
created it unsorts the dates. In my data sheet i have it as January 2008,
February 2008,March 2008 etc yet my columns in the pivot are not in that
order....how can i place them in the correct order?