Apply an Aggregate Function to Data in a Report

After running a new report or opening a saved report, there are many actions you can take to work with the data. One of these options is to apply an aggregate function to the data such as calculating totals, averages, etc. Before doing so, perform any grouping as needed to the data.

1. Click Reporting on the upper navigation bar, and then click Reports & Data Sets.
2. Click Run Report.
   
   
3. Click the gear icon.
   
   
4. Click Aggregate. 
5. Click the Data Column drop-down menu and select the column of data on which the aggregate function will be performed. 
6. Click the Aggregate Function drop-down menu and select the function to be performed.
   
   
7. Click Add. 
   • The aggregate function will now be performed on the column of data selected. If the data was grouped first, the results will be available at the group level as well as at the overall level for the column. 
   • To position the overall results at the bottom of the report, click the Results Positioning drop-down menu and select Bottom. The function name can also be hidden by checking the Hide Function Names box.
     
     
8. Click Save Changes.