Analysis Services
BottomSum
Sorts a set using a numeric expression and returns the specified number of bottommost elements whose sum is at least a specified value.
Syntax
BottomSum(«Set», «Value», «Numeric Expression»)
Remarks
This function sorts on «Numeric Expression» and picks up the specified number of bottommost (the smallest number possible) elements such that their sum is at least «Value».
Important The BottomSum function, as with the TopSum function, always breaks the hierarchy.
Example
BottomSum(Products.[Product Description].Members, 100000, Quantity)