User manual

3-10 FileMaker Pro User’s Guide
Sorting records by subsummary values
If you have a subsummary report (a report with grouped data and
totals), the report is sorted by the category that produced the totals.
For example, if you have a report that subtotals sales by region, the
report is sorted by region (Example 1). You can also sort records by
subsummary values. For example, you can sort the sales regions by
their sales totals (Example 2).
In both examples, Total Sales is a summary field that gives regional
totals when grouped by Region.
Example 1:
Example 2:
This procedure is documented in Help. Choose Help menu > Contents
and Index, click the Index tab, and type sorting records.
For more information on reports with grouped data, see “Creating
layouts and reports” on page 6-2.
Report with grouped
data and subtotals
Regions are sorted
in ascending order
Regions are sorted
in descending order
by Total Sales
Report with grouped data and subtotals,
sorted by subsummary values