Is there a way to average a sum at a group level???
Ok, I have 12 weeks worth of data grouped to a weekly count I also need to get an average of the whole twelve weeks and compare that to the last week of data.
So currently I see this...
Grouped on date printed for each week
8/8/2010 129 6 4.65%
8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%
I need to see this...
8/8/2010 129 6 4.65%
12 Wk Avg 126 7 5.37%
8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%
Can I even do what I want, can I get a "avg total" at a group level????
Ok, I have 12 weeks worth of data grouped to a weekly count I also need to get an average of the whole twelve weeks and compare that to the last week of data.
So currently I see this...
Grouped on date printed for each week
8/8/2010 129 6 4.65%
8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%
I need to see this...
8/8/2010 129 6 4.65%
12 Wk Avg 126 7 5.37%
8/1/2010 233 4 1.72%
7/25/2010 051 2 3.92%
7/18/2010 069 3 4.35%
7/11/2010 092 4 4.35%
7/4/2010 139 2 1.44%
6/27/2010 190 5 2.63%
6/20/2010 128 3 2.34%
6/13/2010 163 5 3.07%
6/6/2010 167 4 2.40%
5/30/2010 083 2 2.41%
5/23/2010 140 50 35.71%
5/16/2010 111 1 0.90%
Can I even do what I want, can I get a "avg total" at a group level????