TopPercent

Return to: Calculated Member Builder Function List

Sorts a set and returns the top N elements whose cumulative total is at least a specified percentage.

Syntax

TopPercent(«Set», «Percentage», «Numeric Expression»)

Remarks

Sorts a set using «Numeric Expression» and returns the top N elements whose cumulative total of «Numeric Expression» is at least «Percentage». «Percentage» is a numeric expression.

This function always breaks the hierarchy. The BottomPercent function is similar.

Example

TopPercent({London, Paris, Rome, New York, Seattle, Tokyo}, 15, Sales)