The MDX BottomPercent function returns the smallest possible subset of a set for which the total results of a numeric evaluation are at least a given percentage. The result set is returned with elements listed from smallest to largest.

Syntax

BottomPercent ( set, percentage, numeric_value_expression )

Arguments

set

The set from which the bottom-percentile elements are selected.

percentage

The percentile. This argument must be a value between 0 and 100.

numeric_value_expression

The expression that defines the selection criteria (see MDX Grammar Rules).

Notes

Examples

with
set SSSSSS as filter(descendants(Calendar.[ALL].[2021], 1, SELF_AND_AFTER), (measure.[sales amount]) > 1)
member measure.XXXXXX as (measure.[sales amount]) - 20000
select
bottomPercent(SSSSSS, 25, (measure.[sales amount])) on 10,
{(measure.[sales amount])} on 1
from [Online Store] ;

	sales amount
M1	1440
M2	1440
M3	1440
M4	1440
M5	1440
M6	1440
Q1	4320
Q2	4320
M12	6793
M11	7148