PivotTable Group by Week -- can't sort by Date (just alphabetical)

  • Thread starter Thread starter DaveM
  • Start date Start date
D

DaveM

I've got the Group By week set up fine (7 days), but the sequence I see
now is:
10/14/2003 - 10/20/2003
10/21/2003 - 10/23/2003
etc.
7/15/2003 - 7/21/2003
7/22/2003 - 7/28/2003
etc.

Any way to get these to show in Ascending Date order (without
sequencing manually)?
Thanks!
 
I could play around with the pivot table after I removed the Grouping. I sorted
ascending (I double clicked on the header, clicked advanced and sorted in
ascending order).

Then I regrouped by days (7) and it seemed to work ok.

(xl2002)
 
Back
Top