Sorting date ranges
Posted by Erwin on September 06, 2001 2:29 PM
I have date ranges with the following format...
m/dd/yy - m/dd/yy
When I create a pivot table from this data, the dates do not sort correctly (ie. 8/03/01 - 8/09/01, 8/17/01 - 8/23/01, 8/10/01 - 8/16/01). I have tried to use the sort by feature when creating the pivot table and the data still outputs out of sequence. Help?
Posted by Barrie Davidson on September 06, 2001 2:38 PM
Sounds like your source data is actually text (not date). Try converting your data to a date by using Data|TextToColumns.
If you need any help with this just let me know.
Regards,
Barrie
Barrie Davidson
Posted by Erwin on September 06, 2001 2:48 PM
Thanks Barrie...
I made the change to the source data, refreshed the data, no change. I also tried to re-sort the data...no luck...thoughts?
Posted by Barrie Davidson on September 06, 2001 2:52 PM
Right click on one of the source data cells and select "Format cells". What is the number format (the "Number" tab of the pop-up box) of that cell?
BarrieBarrie Davidson
Posted by Erwin on September 06, 2001 2:54 PM
Barrie,
Category - Date
Type - 3/14/98
Sample - 2/26/01 - 3/4/01
Posted by Barrie Davidson on September 06, 2001 3:08 PM
I couldn't tell from your first message if you had tried double clicking on your date field in your pivot table and then clicking on the advanced option. This will show another pop-up box that provides sort options (on the left). From there you can select ascending/descending based on whatever field you select.
Does this help you?
BarrieBarrie Davidson
Posted by Erwin on September 06, 2001 3:11 PM
I tried that and it still does not sort properly...thoughts?
Posted by Barrie Davidson on September 07, 2001 6:41 AM
Erwin, can you send me a copy of the spreadsheet (you can change any sensitive information) and I'll have a look at it over the weekend?
BarrieBarrie Davidson
