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) |