Use the Summarize Columns action to summarize rows that contain columns of numeric data types. This action respects any filters that you have set up.
In addition to summarizing, you can also show the average, minimum, or maximum. Sum is the current default.
Follow these steps:
- Select multiple records or all records.
- Click .
- Click , followed by the field that you want to summarize.
A window appears with the results of the summary:
If you select all records and your data set spans the page or even the 10,000-row limit, the following prompt appears. The summation will operate on up to 50 million rows if that's how big the data set is.
Alternatively, if the view does not display all records due to page size, you can click on the Information bubble at the bottom of the ActionGrid. Click the link to view a popup with the summarized totals of that field.