BOTTOMCOUNT

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]

Copyright Kyvos, Inc. All rights reserved.