Syntax

TopSum ( set, numeric_value_expression1, numeric_value_expression2 )

Parameters

set

The set from which the highest-summing elements are selected.

numeric_value_expression1

The given sum (see MDX Grammar Rules).

numeric_value_expression2

The numeric evaluation (see MDX Grammar Rules).

Notes

• If the total results of the numeric evaluation do not add up to the given sum, an empty set is returned.

• This function ignores negative and missing values.

Example

The following MDX query selects the top-selling markets that collectively contribute 60,000 to the total yearly Diet products sales, and displays the quarterly sales for each Diet product:

SELECT
 CrossJoin(
          [Product].[Diet].Children,
          [Year].Children
          ) 
ON COLUMNS,
 TopSum(
       [Market].Levels(0).Members,
       60000, 
       [Product].[Diet]
       )
ON ROWS
FROM Sample.Basic
WHERE ([Scenario].[Actual], 
       [Measures].[Sales])

The above query returns the following output: