Sum For Each Director

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

I seem to recall that there was a way to format a report to that a user can
have some kind of subtotal calculation under a specific category in a Report.
For instance, I have a Report formatted as follows:

Report Header
Page Header

Director Header (for each director)

Detail (contains information such as VP name, Sales Rep Name, and amount of
sales for each of three categories) I wanted to add a subtotal in here, so
that, as the Director changes, all the information for Class1, Class2, and
Class3 is totaled up on this line.

Page Footer
Report Footer (nothing is down here).

So basically, I want the sum for each director, not for the entire Class1.
I’m pretty sure there is a way to do this, but I don’t know how to set it up.
If someone knows, please tell me.


Regards,
Ryan---
 
When I look at it closer I think it is going to be a sum for each change in
VP, not for the change in Director. How do I do that? I can sum easy
enough, but how do I perform a sum for a change in name?

Regards,
Ryan---
 
You have Director Header (for each director) so you also need a footer. Do
the group sum in the footer.
 
Back
Top