L
LadyReader
I have some data being exported daily from SQL into Excel. A pivot
table is applied to the data with the columns of the table being the
WeekEnding dates. Although the field format is "date" in both the raw
data and the pivot table column, the pivot table is sorting the columns
according to alphabetic rules; e.g 01/20/2007 sorts before 01/21/2006.
And I do have the autosort option set to ascending for WeekEnding.
Can someone suggest how to get these columns to sort ascending?
Thanks.
table is applied to the data with the columns of the table being the
WeekEnding dates. Although the field format is "date" in both the raw
data and the pivot table column, the pivot table is sorting the columns
according to alphabetic rules; e.g 01/20/2007 sorts before 01/21/2006.
And I do have the autosort option set to ascending for WeekEnding.
Can someone suggest how to get these columns to sort ascending?
Thanks.