Sort Values

In crosstab displays, you can sort the row and column values in ascending or descending order. For example, a report shows the product sales for the previous ten years. You sort the sales figures to order them from the highest figure to the lowest figure. The data remains sorted until you drill down or drill up.

Steps

1. In the PowerPlay Web display, select the row or column in which you want to sort the values.

The row or column becomes highlighted, and the Sort icon appears in the row or column heading.

2. Click the Sort icon, and then choose the order in which you want to sort:
   • Click Sort Descending to sort the values in descending order.
   • Click Sort Ascending to sort the values in ascending order.

The values and the Sort icon change to show the type of sort action that you applied to the row or column.

Tip

• To remove the value sorting, click the Sort icon, and then click No Sort.