Rank Data

You can rank the categories in the rows or columns of a report. When you rank the rows or columns of a report, each row or column value is assigned an ordinal that shows how it performed in relation to the other rows or columns.

The rank ordinals appear in a new row or column. In Explorer reports, the label and values of the rank category are italicized. The italic formatting is removed when you switch to a Reporter report.

You choose whether the highest or lowest value in a category receives a rank ordinal of 1, and how many of the top or bottom results to view. You can sort or hide the rank category. By default, rank categories are hidden in scatter displays.

You can change the default rank settings in Preferences.

By default, rank categories are automatically regenerated when the report data changes. If you clear the Automatically re-rank setting when defining a rank, you can manually re-rank at any time after changing the report. Using manual re-ranking can save time when working with a large data source because the ranking is not updated with every change to the report.

The following constraints for ranking may apply to your report.

• If you hide categories, they are not ranked.
• If you nest categories, ranked categories do not appear in the chart display.
• You cannot rank the "Other" category when using 80/20 suppression.
• Summary values do not receive rank ordinals in Explorer reports.