Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Pivot table sort | Excel Worksheet Functions | |||
Pivot table sort | Excel Worksheet Functions | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Sort pivot table | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |