Database Reference
In-Depth Information
Leading and Trailing Grand Summaries
Sometimes you want to see the totals for the found set as a whole. For example, you may
have interesting summary fields that show averages or other statistics about your data, and
you want to highlight them in your layout. FileMaker calls these layout parts
Grand Sum-
mary
parts.
If you want a grand total
above
all the records, then add a
Leading Grand Summary
part to
the layout, and put your summary fields in it. If you use a
Trailing Grand Summary
part in-
stead, then the grand totals appear after the last record. You can see a leading Grand Sum-
mary in
Figure 15-7
.
Figure 15-7. The People List layout now has a Leading Grand Summary part to show the overall
total at the very top. If you scroll down to see more records, this total scrolls off the top of the list
(unlike the Header part, which never scrolls away).
Subsummary Parts and Printing
You can use Subsummary parts to build high-level reports that break the data down by mul-
tiple nested groups and then roll up all the totals. For instance, your database of product sales
may show order count, revenue, and share information. Using three Subsummary parts, you
can break these down by region, then state, and finally category.
For just the highest-level analysis, you can leave the Body part out of the layout entirely.
When you do, FileMaker doesn't show the individual records at all. Instead, it shows just the
summarized data.
Figure 15-8
shows just such a layout in Layout mode.
