Summing over multiple groups

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi all,

I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.

I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2
will display the total of group1, and group3 will display the total of
group2.

How can I do it?

Thanks,
Ivan
 
Ivan said:
I have a report with 3 groups: group1, group2, and group3. I have a number
field placed on the detail section.

I want to sum up the number field and place the running total on each of the
groups, so that group1 will display the total of the detail section, group2
will display the total of group1, and group3 will display the total of
group2.
Click to expand...


Not totally clear what you want here, but maybe this will do
it?

Add a text box to the group footer section. Set its control
source expression to =Sum(thenumberfield)
and set its RunningSum property to Over All
 
Back
Top