BottomPercent
The BottomPercent function returns, in order of increasing rank, the bottommost rows of a table whose cumulative total is at least a specified percentage.
Syntax
BottomPercent(<table expression>, <rank expression>, <percent>)
Applies to
An expression that returns a table, such as a <table column reference> or a function that returns a table.
Return Type
<table expression>
Remarks
The BottomPercent function returns the bottommost rows in increasing order of rank based on the evaluated value of the <rank expression> argument for each row, such that the sum of the <rank expression> values is at least the given percentage specified by the <percent> argument. BottomPercent returns the smallest number of elements possible while still meeting the specified percent value.
For more information, see TopPercent.