I have a pivot table that toggles markets and products with metrics as row
labels and weeks as column labels. I would like the dates to be sorted from
oldest to most recent but cannot find any ways to do this. I have the
previous 52 weeks ending on 10/24/09 and the first week (when I tell Excel to
sort ascending by weeks is 1/10/09 and then there are some 2008 weeks a few
columns in. I've also tried to change the format of both the data set and
the dates in the pivot table but to no avail. Any thoughts?