Add Rank Categories Based on Measure Values

You can add rank categories to your reports to show rank ordinals.

Ranking adds ordinals to a report so you can compare your categories to one another. For example, you have a report that outlines revenue for all your products. You add a rank category to this report to see which products generated the most revenue.

Categories are ranked by their value in a specific row or column. The rank ordinals appear in a new row or column. The labels and values of the rank category are italicized.

The rank results can be unsorted, meaning that they are not in numerical order, or they can be sorted in ascending or descending order. Rank categories and sort orders are automatically regenerated whenever there is a change to the report data. You can rank more than one row or column in the same report.

You cannot rank forecast calculation or total summary values.

If the rank option is not available, contact your administrator to enable the ranking feature.