Export (0) Print
Expand All


Returns, in order of increasing rank, the bottom-most rows of a table whose cumulative total is at least a specified percentage.

BottomPercent(<table expression>, <rank expression>, <percent>)

An expression that returns a table, such as a <table column reference>, or a function that returns a table.

<table expression>

The BottomPercent function returns the bottom-most rows in increasing order of rank. The rank is 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 that is specified by the <percent> argument. BottomPercent returns the smallest number of elements possible while still meeting the specified percent value.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft