Average a sum 1

[pungigis]

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????

 

[lbass]

If you reverse the week order, you can do it using a variable, and accumulating and counting the percents and then calculating the average in a display formula in the report footer.

-LB

 

[pungigis]

Thank you, worked perfectly.