Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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)
 

See Also

BottomPercent