Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 131
To sort records by subsummary values:
1. Create a report with grouped data and subtotals. Include the field you use to categorize the
records (in this example, Region) and the summary field (here, Total Sales) in the report.
For more information on creating a report with grouped data and subtotals, see Creating a
layout.
Note You can also create a report with grouped data and subtotals in Table View in Browse
mode. See
Creating dynamic reports in Table View.
2. In Browse mode, click Sort in the status toolbar, or choose Records menu > Sort Records.
3. Move the grouping field (Region) to the Sort Order list, or select it if it is already there.
4. Select Reorder based on summary field or click Specify.
5. In the Specify Field dialog box, select a summary field (Total Sales) and click OK.
6. Select a sort order (in this example, Descending order).
7. Click Sort.
8. Click Table View or List View in the layout bar, go to Preview mode, or print to
see the sorted results.
Tip If data is already sorted by the grouping field, you don’t have to re-sort when you add or remove
a summary field in the sort order. Specify the summary field in the Specify Field dialog box as
described above, then click OK.
Related topics
Defining summary fields
Changing summary fields
Sorting records troubleshooting
Records don't sort in the correct order
• If numbers don’t sort correctly (11 is before 2, for example), they are entered in a field
formatted to contain text data. Change the field type to Number. See About choosing a field
type.
• You might have text in a field formatted to contain numbers. Number fields ignore text when
sorting.
• You might have hidden values in a field that is formatted as radio buttons or checkboxes.
Values that are not on the
value list do not show. To display them, add an unformatted copy
of the field to a layout, then click in the field to see what it actually holds.
Regions are sorted in descending order
by total sales
Region
D
A
C
B
Total Sales
1200
800
300
150