BottomSum

Return to: Calculated Member Builder Function List

Sorts a set using a numeric expression and returns the bottom N elements whose sum is at least a specified value.

Syntax

BottomSum(«Set», «Value», «Numeric Expression»)

Remarks

Sorts on «Numeric Expression» and picks up the bottom x (the smallest number possible) elements such that their sum is at least «Value».

This function always breaks the hierarchy. The TopSum function is similar.

Example

Bottomsum(Products.[Product Description].Members, 100000, Quantity)