Return to: Calculated Member Builder Function List
Returns a specified number of items from the bottom of a set, optionally ordering the set first.
BottomCount(«Set», «Count»[, «Numeric Expression»])
Sorts a set according to the value of «Numeric Expression» and returns the bottom «Count» members, where «Count» is a numeric expression.
This function always breaks the hierarchy. The TopCount function is similar.
Bottomcount(Geography.Cities.Members, 5, Sales)