You can retrieve the Top 10 and Bottom 10 values for a selected dimension member.
To rank data for a member:
Click .png){kind=small}
in the member heading, and from the member menu select Value Filter > Top 10 or Bottom 10.
.png)
The grid displays the top 10 or bottom 10 items for the selected member. The filter icon (1).png){kind=small}
in the member heading marks the ranked row or column.
Examples
In the following example, the Product Categories dimension is expanded to Subcategory level and Top-10 ranking is performed by Sales Amount. The result is a list of the 10 top-selling subcategories.
.png)
In the following example, the Product Categories dimension (expanded to Subcategory level) is nested after Sales Channel. In this case, ranking does not remove the nesting but applies the filter to each parent. The result is Top 10 for Internet and Top 10 for Reseller.
.png)
In the following example, Product Categories is nested after Sales Channel and both dimensions are in flat layout. The example illustrates how Top-10 ranking has been performed for the entire grid when there are nested dimensions. To achieve this all nested dimensions must be in Flat layout.
.png)
To remove ranking:
·Click the remove icon in the ranked member’s heading:
.png)
OR
·Click (2).png){kind=small}
in the ranked member’s heading, and from the member menu select Value Filter > Remove Filter.
The grid and chart now display unfiltered data.