Dimension column

Name of dimension column.

Source: Source table

Data type: Date, Number, or Text

Default value: {None}

Specification: Optional

Aggregation column

Name of the column to be aggregated.

Source: Aggregation column is transferred from the source table.

Data type: Number

Default value: {None}

Specification: Optional

Aggregation type

Aggregation type for the column to be aggregated: Average value, Sum, Minimum, Maximum, Count, First row and Last row.

Default value: Average value, if aggregation column selected.

Specification: Mandatory, if aggregation column selected.

Weighting

If the aggregation type is Average value or Sum, a numerical column for weighting of the rows can be specified for each column to be aggregated.

Specification: Optional