Analysis Services Programming
BottomCount
The BottomCount function returns the specified number of bottommost rows in increasing order of rank as specified by an expression.
Syntax
BottomCount(<table expression>, <rank expression>, <count>)
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 value supplied by the <rank expression> argument is used to determine the increasing order of rank for the rows supplied in the <table expression> argument, and the number of bottommost rows specified in the <count> argument is returned.
For more information, see TopCount.