Concepts
Setup
MDX Manual

MDX Introduction
Member Functions

Examples
SDK
ClosingPeriod
CurrentMember
FirstChild
FirstSibling
Lag
LastChild
LastSibling
Lead
OpeningPeriod
ParallelPeriod
Parent
PrevMember

Set Functions
BottomPercent
Children
CrossJoin
Descendants
Except
Filter
Intersect
LateralMembers
Members
Order
Tail
TopCount
TopPercent
Union
Ytd

Numeric Functions
Logical Functions
String Functions
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.

`BottomPercent ( set, percentage, numeric_value_expression )`

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

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

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

```
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 |

Community

Copyright © 2023 euclidolap.com. All Rights Reserved