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.
Syntax
CUBERANKEDMEMBER(connection, set_expression, rank, [caption])
Parameters
- connection: Required. A text string of the name of the connection to the cube
- set_expression: Required. A text string of a set expression, such as a CUBESET function, or a cell reference to a CUBESET function
- rank: Required. An integer value specifying the position of the top value to return (1 = first)
- caption: Optional. A text string displayed in the cell instead of the caption from the cube
Example
=CUBERANKEDMEMBER("Sales", CUBESET("Sales", "[Product].Children"), 1)