Hi

0 1 2 3 4
FIELD1 FIELD2

--------------------------------------------------------------------------------

100 2005 .00 .00 .00 .00 .00
2006 .00 2.33 2.33 2.33 2.33
2007 .00 2.33 2.33 2.33 2.33
Variance .00 .00 .00 .00 .00
--------------------------------------------------------------------------------

200 2005 .00 .00 .00 .00 .00
2006 2.33 2.33 2.33 2.33 2.33
2007 2.33 2.33 2.33 2.33 2.33
Variance .00 .00 .00 .00 .00

I want to calculate AVERAGE at the end of the report corresponding to 2005 , 2006 , 2007 and Variance separately.

I am trying to use SUBTOTAL but it's not working. Could you please help me in finding the same?

Thanks
Deepa

Deepa,

Check out the documentation for prefixes such as PCT, MAX, MIN, AVE, SUM etc.

T