Database Reference
In-Depth Information
Figure 4-24. Choices you make in this window determine how many subtotals your report
will have. You can also place the subtotal above or below the records it's summarizing. You
need to have at least one Subtotal line item in the Subtotals box at the bottom for the sum-
mary to work, though, so make sure you click Add Subtotal after you create or choose a
summary field (you'll learn about them later in this tutorial).
9.
In the Summary Field Name box, type
Count Leases
and then select “Count of.”
Now choose Lease Duration from the “Choose field to summarize” list and then
click OK until you're back on the Specify Subtotals panel. Now click Add Sub-
total. Click Next
.
FileMaker creates a new Count Leases field (Summary type) and adds it to the Sub-
totals list. At the end of this process, you'll see a Subsummary part (you'll learn how
to create them manually on
Summary Fields and Subsummary Parts
)
based on the op-
tions you just chose. The summary field counts each record in the sorted category
group you selected and displays a count of records for each group in its own Subsum-
mary part. Make sure the Lease Agreement::Count Leases field appears in the Sub-
totals list at the bottom of the window. After you click Next, the Specify Grand Totals
window appears.
10.
Click Specify
.
The Specify Field window appears. The Count Leases field you just created appears
in the list.
