Changing summary fields
You can change summary fields; for example, to change the type of summary and the field you want to group data by.
If you change the type of summary calculation, FileMaker Pro recalculates the value for every record in the database when you exit the Manage Database dialog box.
To change a summary field:
1.
With the database open, choose File menu > Manage > Database.
2.
In the Manage Database dialog box, click the Fields tab.
3.
If your database contains more than one table, select the appropriate table from the Table list.
4.
In the Fields tab of the Manage Database dialog box, select the summary field, then click Options (or double-click the field name).
5.
In the Options for Summary Field dialog box, make your changes.
 
To change the
Do this
Type of summary calculation
Select another summary type, like Total of
Options for the summary type
Select or clear options, like Running total
Field you want to group data by
Select a different field name
6.
Click OK.
7.
Continue making changes or click Done.
To change a summary field in Table View:
1.
With the database open in Browse mode, click Table View Table View button in the layout bar.
2.
Right-click the column heading for the summary field and choose Field > Field Options from the shortcut menu.
3.
In the Options for Summary Field dialog box, make the changes you want, then click OK.
Related topics 
Defining summary fields
Summary data is missing or incorrect
Specifying formats for fields containing numbers
Was this topic helpful? Send feedback.