Summarize Query Data

Use the Results tab in a query window to summarize query results.

To summarize query data

In the query window toolbar, click Run. The results appear on a query results tab. In the following example, the View Accounts tab contains the query results.

Query 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