Ranking, sorting and filtering can be applied in two ways: on the hierarchy or on the grid axis.

To rank, sort, and filter in axis mode, right-click the column or row header. To access hierarchy mode select the Advanced tab on the member selector for the relevant hierarchy. 

Axis mode is a quick approach to ranking, sorting, and filtering can be thought of as result-set ranking. Here the ranking is applied to an entire axis (for example, a column or row).

To apply axis ranking:

  1. Right-click the column/row header that you wish to rank and select Anaplan XL > Apply > Ranking > 
  2. Select the ranking. Top 10 and Bottom 10 are options. To rank other counts, select Top x Rows or Bottom x Rows and you will be prompted to enter a figure. The ranking is applied. A red indicator appears on the first member of the ranked hierarchy to show that the axis is being ranked.
  3. To edit or remove the ranking, right-click Anaplan XL > Axis >.

The ranking is fixed to the axis, so if, for example, you apply a top 5 ranking for Geography and then switch Geography with Product, you see the top five Products without having to reapply the ranking. Where you have two hierarchies on the axis, the result is the top five intersections between the two hierarchies.