Minimum

Finds all rows that have a particular combination of values in the dimension columns and returns the lowest value that occurs in these rows in the column to be aggregated.

Maximum

Finds all rows that have a particular combination of values in the dimension columns and returns the highest value that occurs in these rows in the column to be aggregated.

Average value

Finds all rows that have a particular combination of values in the dimension columns and returns the average of the values in the column to be aggregated. For weighting purposes, an additional column can be specified for each source column, containing a weighting factor for each row. The weighting information is combined as a pair with the source column.

Sum

Finds all rows that have a particular combination of values in the dimension columns and returns the sum of the values in the column to be aggregated. For weighting, an additional column can be specified for each source column, containing a weighting factor for each row. The weighting information is combined as a pair with the source column.

Count

Finds all rows that have a particular combination of values in the dimension columns and returns the count of values in the column to be aggregated.

First row

Finds all rows that have a particular combination of values in the dimension columns and returns the value of the row with the lowest row index (according to the index column).

Last row

Finds all rows that have a particular combination of values in the dimension columns and returns the value of the row with the highest row index (according to the index column).