BOTTOMPERCENT

Description:

This function is used to sort a set in ascending order, and returns a set of tuples with the lowest values whose cumulative total is equal to or greater than a specified percentage.
Syntax:

Aggregate(Set_Expression [ ,Numeric_Expression ])

Return Type:
SCALAR

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Percentage	A valid numeric expression that specifies the percentage 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,  
BottomPercent  
   ({[Customer].[Geography].[City].Members}  
   , 15  
   , ([Measures].[Reseller Average Sales Amount],[Product].[Product Categories].[Category].&[Bikes])  
   ) ON 1  
   
FROM  
     [AdventureWorksMF]

Kyvos 2025.2

BOTTOMPERCENT

Analytics

Related content