In addition to the normal ability to drive member selections from Excel ranges, you can also drive other parameters.

OptionDescription
Ranking - CountSets the number of items to be returned. (Any number)
Ranking - TypeSet whether to return the top or bottom n elements. (Valid values are top or bottom)
Filter - OperatorHow to compare the measure when filtering. (Valid values are >, >=, <, <=, =, <>)
Filter - MeasureThe measure to use when filtering. (Any valid measure)
Sorting - DirectionAllows you to reverse the order as required. (Valid values are asc, ascending, desc, descending)