Filtering by Ranking Data Values

  To rank data based on top or bottom criteria or both:

  1. To display the data filter panel, in the navigation panel, select Data Filtering.

  2. In the data filter panel, select a Rank option:

    • To retrieve the top n rows of a dimension, select Top and specify the number of rows to be retrieved.

      The default is the top 25 rows.

    • To retrieve the bottom n rows of a dimension, select Bottom and specify the number of rows to be retrieved.

  3. From Dimension being ranked, select a row dimension to which ranking should be applied.

  4. 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.

Related Topics

Applying Multiple Data Filters

Filtering by Comparing Data Values

Creating Data Sorts