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
WebFocus 7.1.4, Windows Server 2005 , HTML/EXL/PDF