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 TopPercent function returns the smallest possible subset of a set for which the total results of a numeric evaluation are at least a given percentage. Elements in the result set are listed from largest to smallest.

`TopPercent ( set, percentage, numeric_value_expression )`

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

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

The expression that defines the selection criteria.

```
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
topPercent(SSSSSS, 25, (measure.[sales amount])) on 10,
{(measure.XXXXXX)} on 1
from [Online Store] ;
```

XXXXXX | |

Q3 | 2088 |

Q4 | 1231 |

Community

Copyright © 2023 euclidolap.com. All Rights Reserved