Tutorial

Lesson 9
|
Creating and running reports 63
In the Membership Fee Report, you want to see subtotals for fees paid by each type of member, New and
Continuing, and to see a grand total of both groups’ fees at the end of the report. To accomplish this, you
need to specify subtotal and grand total summary fields in the New Layout/Report assistant.
The summary field you will use is Membership Revenue, which has already been defined for you in the
Sample file. Membership Revenue totals the fees entered in the Fee Paid field.
1. For Summary field, click Specify and select Membership Revenue from the list of available fields, then
click OK.
2. For Category to summarize by, use the default value of Membership Type.
3. For Subtotal placement, use the default value of Below record group.
4. Click Add Subtotal to add the Membership Revenue field as the subtotal. This tells FileMaker Pro to
create a subtotal of the membership fees that are paid beneath each membership category.
5. Click Next.
6. For Summary field, click Specify and select Membership Revenue from the list of available fields, then
click OK.
This tells FileMaker Pro to use the Membership Revenue field in the grand total.
7. Click Add Grand Total to add the Membership Revenue field as the grand total at the end of the report.
This tells FileMaker Pro to create a grand total of membership fees.
8. Click Next.