topCount
Sorts a set according to the values of "numeric_expression" evaluated at each of the members of "set_expression" and returns the top "index_expression" members.
Syntax
topCount ( set_expression , index_expression , numeric_expression )Example
topCount ( [great_outdoors_company].[Products].[Products].[Product
line] , 2 , [Revenue] )Result
Returns the top two revenues for the Product line set.
Result data
| Prod line | Revenue |
|---|---|
| Camping | $89,713,990.92 |
| Personal | $31,894,465.86 |