Ranking

You can use the ranking option to narrow your view to the most or least successful data subsets, respectively.

For example, you can use Top count or Bottom count to display the 5 regions in which the most or least revenue was earned. Or specify a value and use Top sum or Bottom sum to display the sales persons whose combined sales equaled or exceeded that value. Or specify a percentage and use Top percent or Bottom percent to display the products that contribute up 30% of the total turnover.

Ranking displays a subset of values. These are the available ranking options:

• None
• Top count
• Top sum
• Top percent
• Bottom count
• Bottom sum
• Bottom percent