Analysis Services
Aggregate Functions
Microsoft® SQL Server™ 2000 Analysis Services provides the following aggregate functions for use in measures.
| Aggregate function | Returned value |
|---|---|
| Sum | The sum of the input values. |
| Min | The lowest of the input values. |
| Max | The highest of the input values. |
| Count | The number of input values. |
| Distinct Count | The number of unique input values. |
A function is selected in the Aggregate Function property of a measure. This property is accessed in the properties pane of Cube Editor. For more information about how you can use these functions in real-world scenarios, see Using Aggregate Functions.