The following is a portion of a data set based on weekly data (see bottom)

Is there any way to compute this in a monthly format so it will sum on both
dimensions?

ie.
July 2008 Aug 2008 Sept 2008
Dec 2007 4
Jan 2008 332 5
Feb 2008 1,110 136

Thanks.


5-Jul-08 12-Jul-08 19-Jul-08 26-Jul-08 2-Aug-08
29-Dec-07 4
5-Jan-08 8 5
12-Jan-08 32 11 7
19-Jan-08 77 42 15 9
26-Jan-08 56 40 22 8 5
2-Feb-08 147 116 84 46 16
9-Feb-08 41 49 38 28 15
16-Feb-08 87 76 89 70 51
23-Feb-08 45 67 58 68 54
1-Mar-08 53 79 118 102 121
8-Mar-08 60 52 78 117 101