Is this conditionally summing rows or is it a sum of all the rows?
If condtional please explain the row level data and the conditions, if it is for all just use the Summary function at group level 1 and group level 2.
Click on the field to SUM to activate it.
Click on the Insert Summary button (Sigma)
Field should already be the correct one but change it if you need to.
Make the calculate as a SUM
Change the location as Group 1.
It will dropr the field on your group footer1.
Do the exact same thing as but make the change loaction group 2.
It will drop the field on the group footer2
As an FYI shortcut...
If you have already create a Summary field using the insert summary option at one group level you can make a copy of that field (ctrl +c) and paste it (ctrl +v) onto the another group level and the pasted one will adjust itself to summing at that level without changing the original...
or if you make one at the wrong group level just drag and drop it on the correct level and it will adjust itself.
These summaries can be used in HEaders or footers whereas RTs can not be used in headers.
Edited by DBlank - 26 Aug 2009 at 2:36pm
IP Logged
