Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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