Summarize Query Data

Use the Results tab in the Select Accounts window to summarize query results.

To summarize query data

With the Select Accounts window open, in the toolbar, click Run. The results appear on the Results tab.

Select Accounts window - Results tab

In the column heading, click the Sigma icon. The Select Summaries dialog box appears. The options available are based on the item's data type.

Select Summaries dialog box

Select the calculations to perform on the data and then click OK. The result appears in the last row of the data grid. If you grouped data, the system calculates the data for each group and displays the results in the last row for each group.

Results tab - summarized data