TopCount

Return to: Calculated Member Builder Function List

Returns a specified number of items from the top of a set, optionally ordering the set first.

Syntax

TopCount(«Set», «Count»[, «Numeric Expression»])

Remarks

Sorts a set according to the value of «Numeric Expression» and returns the top «Count» members, where «Count» is a numeric expression.

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

Example

Topcount(Geography.Cities.Members, 5, Sales)

 

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