Add Rank Categories Based on Measure Values

You can now add rank categories to your PowerPlay Web Explorer 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 can add a rank category to this report to see which products had the highest 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. For example, when you rank products by their value in the Revenue category, PowerPlay Web adds a rank column to the report that shows what place each product came in. If you want to see the top ten revenue-generating products, you sort the rank category to arrange the ordinals in numerical order.

Rank categories and sort orders are automatically regenerated whenever there is a change to the report data.

PowerPlay Web reports with rank categories can be exported to PDF , CSV or Excel format, saved to the portal , and bookmarked .

You cannot rank forecast calculation or total summary values. You can add rank categories only if your PowerPlay Web administrator enabled the settings in PowerPlay Enterprise - Server Administration.

Steps

1. In the PowerPlay Web Explorer report, right-click the column or row on which you want to base the rank category, and then click Insert Rank.

You can rank on more than one column or row.

2. Verify the category on which you want to base the rank category.
3. In the Show Ordinals list box, click Top, Bottom or All, and type the number of ordinals you want to show.

Type Top to show the highest values, Bottom to show the lowest values, or All to show all the values.

4. In the Start the Ordinals From list box, click Highest or Lowest to identify which ordinal is ranked as ordinal 1.
5. In the Sorting Order list box, click Descending, Ascending, or None to set the sorting order.
6. In the Rank Name box, specify a name for the rank category.

The rank category name appears at the top of the column or beginning of the row in italicized text.

7. Click OK.

Tip: You can also use the Rank button on the PowerPlay Web toolbar to add, delete, edit, or rename a rank category.

The new rank category appears in the PowerPlay Web Explorer report, to the right of the selected column or under the selected row.