To rank data based on top or bottom criteria or both:
To display the data filter panel, in the navigation panel, select Data Filtering.
From Dimension being ranked, select a row dimension to which ranking should be applied.
From Column being used for ranking, select a column dimension member combination.
The member combinations listed here are determined by the members that you selected for the column dimensions. The data values for the specified column dimension members are used to determine the ranking for the members in the row dimension.
Next, you can sort the data, or apply the query now.
Applying Multiple Data Filters