You can add aggregation fields to the Dynamic View Report using the Aggregation dialog box.
The aggregation columns are based on the data fields, and calculated with a standard SQL aggregate operation (SUM, MAX, MIN, COUNT, AVG) or a ratio expression (the formula for ratio expression is SUM(<data field>/ SUM(<ratio data field>))). Only numeric fields and calculated fields are used in a statistic expression.
There are 2 types of aggregation fields:
1. Plain aggregation fields, which are displayed in the same way as all other fields.
2. Total fields, which are displayed under the columns, for which they are calculated, if the columns are present in the view, or behave like plain aggregation fields otherwise.
To display the Aggregation dialog box, on the Dynamic View Report page, after you assign column headings to hierarchy levels, point to a column heading on any hierarchy level, and click the plus sign that will appear on the right of its name.
The Aggregation dialog box appears. It contains:
Name: By default, the title of the column and the name of the aggregation function used. A custom name can be entered by checking the Override Name check box next to it.
Aggregate Function: Select the aggregate operation (Sum, Max, Min, Count, Average, Ratio).
Apply: Click to add the statistic field to the Dynamic View Report.
Cancel: Click to cancel the operation.
You can change the level of a field in the Dynamic View, by dragging it to another level.
To remove a field from Dynamic View, click on the cross symbol preceding the field's name.