A rank is a type of filter that selects cell values
based on their contribution to an overall total. The selected cells are then
sorted in ascending or descending order, depending on the rank condition.
For example, a data analyst may start with a
crosstab that shows all product brands. She then performs a ranking action to
see only the unit sales of the Top 20 product brands, sorted from highest to
lowest unit sales.
A rank action is performed on a single column or
row. On an axis that has nested dimensions, the selected member must be on the
innermost dimension.