Pivot Table sort

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

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?
 
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
 
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/excel/HP012165021033.aspx
 
Back
Top