Export (0) Print
Expand All

BottomPercent

SQL Server 2000

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)
 

See Also

TopPercent

Show:
© 2014 Microsoft