fbpx

TopPercent (MDX)

Returns a sorted (descending order) 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   
sum  numeric-expression  one 
measure  value-expression  one   

Return

set

Description

The function sorts the set in descending 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 highest value is returned.

See Also

TopCount TopSum BottomPercent BottomCount BottomSum

Examples

Special Examples (errors, null, ...)

XMLA Properties

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