CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.
CubeCube & Data Models
What it does
Returns the nth member from a set (e.g., top 10).
Syntax
CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
Arguments
connection(text) — Connection name.set_expression(text) — Set MDX or CUBESET reference.rank(number) — Rank (1 for top).
Examples
Top 1 Product
Get the top ranked item.
FORMULA
=CUBERANKEDMEMBER("Sales", $A$1, 1)RESULT
Bike
SAMPLE DATA
| A | |
|---|---|
| 1 | Set Ref |
| 2 | (Set) |