fbpx

BottomSum (MDX)

Returns an ascending sorted set which 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 ascending order according to the specified measure and returns the minimum number of elements whose cumulative sum is more or equal to the specified value.

If 0 was specified as a value the member with the lowest value is returned.

See Also

TopSum BottomCount TopCount BottomPercent TopPercent

Examples

Special Examples (errors, null, ...)

XMLA Properties

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