Hello, I'm looking for a way to organize this kind of data:
Date Open Date Closed
Issue 1 2012-01-01 2012-01-06
Issue 2 2012-01-05 2012-01-08
Issue 3 2012-01-10 2012-01-18
Issue 4 2012-01-14 2012-01-18
Issue 5 2012-01-15 2012-01-16

Into a pivot table... that is grouped by week, and has two counts for each week: # of issues opened that week, and # of issues closes that week:
Date # opened # closed
Jan1-7 2 1
Jan8-14 2 1
Jan15-21 1 3

The problem I am having is getting these sorted by weeks, without using either Date Open or Date Closed as the pivot table row labels. If I use either of those (DateO, I would get something like this:
Row Labels Count of Date Open Count of Date Closed
2012-01-01 - 2012-01-07 2 2
2012-01-08 - 2012-01-14 2 2
2012-01-15 - 2012-01-16 1 1

Thanks.