Help

Adding and viewing data
F
ILEMAKER PRO HELP 66
To group data by a field:
1. In Browse mode, right-click the column heading for the field that you want to use for
grouping the data, then choose Add Leading Group by <field name> or Add Trailing
Group by <field name>.
For example, if you want to display the sales data by City and add a summary row at the end of
the records for each city, choose Add Trailing Group by City. If you want to add the summary
row before the records for each city, choose Add Leading Group by City.
Adding a leading/trailing group automatically sorts the records by the field that you used for
grouping the data. For example, the cities will be listed in alphabetical order.
2. If you want to change the color of the summary row for each group, right-click the left or right
margin of the summary row and choose a color from the Part Color shortcut menu.
3. If you want to display the name of each group in the summary row, right-click the left margin
of the summary row, then choose Add Group Field (<field name>).
Tip You can add leading/trailing groups for multiple fields to display different categories for each
group of records.
To remove a group:
• In Browse mode, right-click the column heading for the field that you used for grouping the
data, then choose Remove Leading Group by <field name> or Remove Trailing Group
by <field name>.
To display subtotals:
1. In Browse mode, right-click the column heading of the field that you want to display
subtotals for.
2. Choose Leading Subtotals or Trailing Subtotals, then choose options from the shortcut
menu.
Select To
Total Calculate the total of values in the field.
Running Total Show the cumulative total for the current and all previous sorted groups.
Average Calculate the average of values in the field.
Count Count the number of records that contain a value for the field. For
example, if a field contains 100 values (one value for each record), the
result of the count is 100.
Running Count Show the cumulative count of the current and all previous sorted groups.
Minimum Show the lowest number, or earliest date, time, or timestamp for a field.
Maximum Show the highest number, or latest date, time, or timestamp for a field.
Standard Deviation Find how widely the values in a field differ from each other. This option
calculates the standard deviation from the mean of the values in a field.
Standard Deviation By
Population
Calculate population standard deviation.
Fraction of Total Calculate the ratio of the value in the field to the total of all the values in
that field. For example, find what fraction of total sales can be attributed to
each salesperson.