count
Returns the number of selected data items excluding null values.
Syntax
count ( < currentMeasure|numeric_expression > within set
set_expression )
count ( < currentMeasure|numeric_expression > within <
detail|aggregate > expression )Example
count ( Sales )Result
Returns the total number of entries under Sales.