BOTTOMCOUNT

Description:

This function is used to sort a set in ascending order, and returns the specified number of tuples in the specified set with the lowest values.

Syntax:

BottomCount(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	A valid numeric expression that specifies the number of tuples to be returned.
Numeric_Expression	A valid numeric expression is typically an MDX expression of cell coordinates that returns a number.

Example:

select [Measures].[Internet Order Quanlity] on 0,
  BottomCount([Product].[Product Categories].[Sub Category].Members  
   , 10  
   , [Measures].[Reseller Average Sales Amount])  ON 1  
FROM  
     [AdventureWorksMF]

Kyvos 2025.2

BOTTOMCOUNT

Analytics

Related content