Anaplan XL Reporting provides two modes of ranking: hierarchy ranking and axis ranking.

Learn more about hierarchy ranking, sorting, and filtering. 

Axis mode is an approach to ranking, filtering, and sorting that can be thought of as result-set ranking. Here, the ranking is applied to the axis, rather than the hierarchy itself.

So, for example, if you have Geography on rows and Products on filters and then apply a top 5 ranking on rows, you get the top 5 Geographies. If you then switch Geography with Product, you will get the top 5 Products without having to re-apply the ranking.

Where you have two or more hierarchies on the axis, the result will be the top 5 intersections between the two hierarchies. This is shown below in contrast to Hierarchy ranking which returns the top 5 members for each hierarchy.

Ranking, filtering, and sorting are most often used on the row axis, but can also be applied to the column axis.

  •  Select a column header or a data cell to apply ranking, filtering, or sorting to the rows in the context of the corresponding column.
  • Select a row header to apply ranking, filtering, or sorting to the columns in the context of the corresponding row.

Then, choose Apply from the Anaplan XL right-click menu or the grid's ribbon to choose the type of filtering to apply. If you select Ranking> Top x Rows/Bottom x Rows, you will be prompted to enter the number of rows/columns to return.

This applies a ranking, limiting the number of rows/columns returned, an indicator appears on the first row/column's member.  You can right-click on this cell and select Anaplan XL > Axis, which will enable you to:

  • Edit the applied ranking (or sort/filtering).
  • Clear all ranking/sorting/filtering on that axis.

The Axis > Edit... dialog can also be accessed from the Report Designer window by selecting the icon to the right of the axis name. 

The Excluded Slices tab allows you to remove certain members from your report (review also Keep Members).

IconDescription
Select to add an exclusion list.
Select to clear all current exclusions.