- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Cube - CUBERANKEDMEMBER Function
Description
The CUBERANKEDMEMBER function returns the nth, or ranked, member in a set.
Use this function to return one or more elements in a set, such as the top sales performer or the top 10 students.
Syntax
CUBERANKEDMEMBER (connection, set_expression, rank, [caption])
Arguments
Argument | Description | Required/ Optional |
---|---|---|
connection | The name of the connection to the cube. - A text string. | Required |
set_expression | A set expression. - A text string, E.g. "{[Item1].children}". OR The CUBESET function. OR A reference to a cell that contains the CUBESET function. |
Required |
rank | An integer value specifying the top value to return. E.g.: 1 - Returns the top value, 2 - Returns the second top value, etc. To return the top 5 values, use this Function five times, specifying a different rank, 1 through 5, each time. |
Required |
caption | A text string displayed in the cell instead of the caption, if one is defined, from the cube. | Optional |
Notes
When the CUBERANKEDMEMBER function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.
If the connection name is not a valid workbook connection stored in the workbook, CUBERANKEDMEMBER returns a #NAME? Error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBERANKEDMEMBER returns a #NAME? Error value.
CUBERANKEDMEMBER returns a #N/A error value when the syntax of set_expression is incorrect or when the set contains at least one member with a different dimension than the other members.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016