Aggregating Value Columns Based on Type

Each of the value column configured to widget, can be aggregated individually based on the type you define. Following table illustrates the aggregation types and their use.

Aggregation Type	Result
Sum	Calculates the sum of values of all members.
Count	Returns the count of all members.
Average	Calculates the average of values of all members.
Max	Returns the highest value for all members.
Min	Returns the lowest value for all members.
StdDev	Calculates the standard deviation of all members.
Var	Calculates the variance of all members.
DistinctCount	Returns the distinct count of all members.
Weighted Score	Calculates the weighted average of all members based on another column defined.

Note

SSAS data source don’t have this option enabled for value columns as these columns were pre-aggregated in cube itself.