What are your expected results?
i.e.: When I see a table with row headers and column headers such as you
have, I expect the intersection to be relevant to each.

So how does July 5, 2008 and December 29, 2007 = 4? What exactly are you
summing.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"Tuppie11" wrote:

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