Return to: Calculated Member Builder Function List
Sorts a set and returns the top N elements whose cumulative total is at least a specified value.
TopSum(«Set», «Value», «Numeric Expression»)
Sorts on «Numeric Expression» and picks up the top N (the smallest number possible) elements such that their sum is at least «Value».
This function always breaks the hierarchy. The BottomSum function is similar.
Topsum(Products.[Product Description].Members, 100000, Quantity)