BottomSum

Analysis Services

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)
 

See Also

TopSum