TOPCOUNT

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

Description:

This function is used to sort a set in descending order and returns the specified number of elements with the highest values.

Syntax:

TopCount(Set_Expression,Count [ ,Numeric_Expression ] )

Return type:

SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Count	It is a valid numeric expression that specifies the number of tuples to be returned.
Numeric_Expression	It is a valid numeric expression, typically an MDX expression of cell coordinates that returns a number.

Example:

WITH MEMBER [Measures].[Top 10 Sales] AS
    SUM(TopCount([Product].[Product].[Product].Members, 10, [Measures].[Internet Sales Amount]),
        [Measures].[Internet Sales Amount])
SELECT {[Measures].[Internet Sales Amount], [Measures].[Top 10 Sales]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]