Analysis Services
BottomPercent
Sorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified percentage.
Syntax
BottomPercent(«Set», «Percentage», «Numeric Expression»)
Remarks
This function sorts a set specified in «Set» and returns the specified number of bottommost elements whose cumulative total of «Numeric Expression» is at least «Percentage». «Percentage» is a numeric expression.
Important The BottomPercent function, as with the TopPercent function, always breaks the hierarchy.
Example
BottomPercent(Products.[Product Description].Members, 25, Sales)