TopSum

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.

Syntax

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

Remarks

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.

Example

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

 

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.