Sum For Each Director

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---
 
R

ryguy7272

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---
 
K

KARL DEWEY

You have Director Header (for each director) so you also need a footer. Do
the group sum in the footer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top