Adding and removing an aggregate value
When you aggregate data in a column, you specify the following information:
The type of aggregate calculation. The report in
Figure 5‑14 displays, for the Total column, the sum of the values, the highest (max) value, and the average value. Interactive Viewer supports other types of aggregate functions, described later in this document. Each aggregation appears on a separate row.
Whether to perform the aggregate calculation across all the data rows in the table, or across the data rows in each group, or both. Aggregating data for groups applies only to reports that organize data in groups.
Whether to display the aggregate data in the footer or header of the table or the groups. The previous examples show aggregate data in the footers, which is typical. Choose header to display the aggregate data at the beginning of the table or group.