TABLE 1: Analysis Services Native Aggregation Types
Aggregation Type How Cell Is Derived from Fact Table Records How Cell Is Aggregated
Sum Summation Summation
Count Count Summation
Min Minimum value Minimum value
Max Maximum value Maximum value
Distinct count Distinct count N/A -- All values are loaded