In addition to the normal ability to drive member selections from Excel ranges, you can also drive other parameters.
Option | Description |
Ranking - Count | Sets the number of items to be returned. (Any number) |
Ranking - Type | Set whether to return the top or bottom n elements. (Valid values are top or bottom ) |
Filter - Operator | How to compare the measure when filtering. (Valid values are >, >=, <, <=, =, <>) |
Filter - Measure | The measure to use when filtering. (Any valid measure) |
Sorting - Direction | Allows you to reverse the order as required. (Valid values are asc, ascending, desc, descending) |