bottomCount
Sorts a set according to the value of "numeric_expression" evaluated at each of the members of "set_expression" and returns the bottom "index_expression" members.
Syntax
bottomCount ( set_expression , index_expression , numeric_expression )Example
bottomCount ( [great_outdoors_company].[Products].[Products].[Product
line] , 2 , [Revenue] )Result
Returns the bottom two members of the set sorted by revenue.
Result data
| Prod line | Revenue |
|---|---|
| Camping | $3,171,114.92 |
| Personal | $20,891,350.60 |