fbpx

BottomPercent (MDX)

Returns a ascending sorted set which cumulative percent is greater or equal than the specified percent (i.e., a value between 0 and 100).

Parameters

Name Type Cardinality Default value
set  set-expression  one   
percent  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 percent is greater or equal to the specified percent.

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

See Also

TopPercent BottomCount TopCount BottomSum TopSum

Examples

Special Examples (errors, null, ...)

XMLA Properties

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