Regular aggregate property
The Regular Aggregate property
identifies the type of aggregation for the query item or calculation
when you publish it. Your users can either use this default setting
to perform calculations on groups of data, or apply a different
type of aggregation.
For example, if the Regular Aggregate property value of the Quantity query item is sum, and it is grouped by Product Name in a report, the Quantity column in the report shows the total quantity of each product.
The following aggregation types are supported for relational data sources:
- Automatic
- Average
- Calculated
- Count
- Count distinct
- Maximum
- Minimum
- Sum