Analysis Services
TopPercent
Sorts a set and returns the topmost elements whose cumulative total is at least a specified percentage.
Syntax
TopPercent(«Set», «Percentage», «Numeric Expression»)
Remarks
This function 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.
Important Like the BottomPercent function, this function always breaks the hierarchy.
Example
TopPercent({London, Paris, Rome, New York, Seattle, Tokyo}, 15, Sales)