Totals and Averages

The Totals and Averages configuration tool provides options for including column totals and/or averages at the bottom of the numeric columns in a report.

Enable Column Totaling

There are two ways to enable column totals on a column. The first is from the Totals and Averages configuration tool.  For the column(s) you want to total, select Display Totals from the dropdown menu next to the column(s). The second way is to select Display Totals from the column header menu for the desired column.

Only columns that have been configured with the Numeric data type will be available for totaling. The exception to this is Date Range columns, which are automatically set up for totaling.

Enable Column Averages

There are two ways to enable column averages on a column.  The first is from the Totals and Averages configuration tool.  For the column(s) you want to average, select from the dropdown menu next to the column(s).  The second way is to select Display Averages from the column header for the desired column. 

Column averages in MITS Report are rounded down.

Only columns that have been configured with the Numeric data type in the Report Source will be available for averaging.

Removing Totals and Averages

There are two ways to remove totals or averages from a report.

The first is from the Totals and Averages configuration tool.  Select the None in the dropdown menu next to the column that should have totals or averages removed.

The second is while viewing a report.  Select Remove Totals or Remove Averages (as appropriate) from the column menu of the column that should no longer display totals or averages.

Total and Averages cannot be removed from Date Range columns.