Aggregation

You can add statistic fields to the Dynamic View Report using the Aggregation dialog box.

The statistic 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 two types of statistic fields:

• Plain statistic fields, which are displayed in the same way as all other fields.

• Dynamic fields, which are displayed under the columns, for which they are calculated, if the columns are present in the view, or behave like plain statistic 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 sum symbol 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 checkbox 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.

To change the level of a field in the Dynamic View, drag it to another level.

To remove a field from Dynamic View, click on the cross symbol preceding the field's name.