Analysis Services
TopSum
Sorts a set and returns the topmost elements whose cumulative total is at least a specified value.
Syntax
TopSum(«Set», «Value», «Numeric Expression»)
Remarks
This function sorts on «Numeric Expression» and picks up the top n (the smallest number possible) elements such that their sum is at least «Value».
Important Like the BottomSum function, this function always breaks the hierarchy.
Example
Topsum(Products.[Product Description].Members, 100000, Quantity)