BottomPercent

Return to: Calculated Member Builder Function List

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

Syntax

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

Remarks

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

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

Example

Bottompercent(Products.[Product Description].Members, 25, Sales)