fbpx

TopSum (MDX)

Returns a sorted set (descending order) which member's values cumulative sum is greater or equal than the specified sum value.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
sum  numeric-expression  one 
measure  value-expression  one   

Return

set

Description

Function sorts the set in the descending order according to the specified measure and returns the minimum number of elements whose cumulative sum is greater or equal to the specified sum.

If 0 was specified as a value the member with the highest value for measure is returned.

See Also

TopCount TopPercent BottomSum BottomCount BottomPercent

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.