Summarize Query Data

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

To summarize query results

Create a Query or Open an Existing Query.
In the toolbar, click Run. The results appear on the Results tab. The following example shows the Results tab in the Account Analysis window.

Account Analysis 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.

Query results summary