Apply an Aggregate Function
You can assign an aggregate function to columns that contain numeric and non-numeric values in your report. Aggregate functions return a single value (for example, Average, Maximum, Minimum), calculated from the values in a column. For example, the sum of a column results from adding all the values in the column.
- Click the down arrow next to a report column that contains numeric values.
- Select Aggregation from the menu, then choose the aggregation type.
Function Name Description None No aggregate function assigned Average Calculates the average value in a given column Count Counts the items in a column; does not require a numeric value Count Distinct Counts the distinct occurrences of a certain value in a column; does not require a numeric value Max Identifies the highest or largest value in a column Min Identifies the lowest or smallest value in a column Sum Calculates a running total sum of the specified column The values in the column update.
- Save the report.