Anaplan XL Reporting provides two modes of ranking: hierarchy ranking and axis ranking.
Learn more about hierarchy ranking, sorting, and filtering.
Axis ranking, filtering, and sorting
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 columns 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.
Applying Axis Ranking
Axis ranking is applied through Anaplan XL’s right-click menu, and is based on the column/row header, not from within a specific hierarchy.
Right-click on the column or row header that you wish to rank by and then select Anaplan XL > Apply. Here you can select whether to sort, rank, or filter. If you select to rank Top x Rows/Bottom x Rows, you will be prompted for the number of rows to return.
This'll apply a ranking, limiting the number of rows returned, so an indicator appears on the first row 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 Excluded Slices tab allows you to remove certain members from your report (review also Keep Members).
| Icon | Description |
 | Select to add an exclusion list. |
 | Select to clear all current exclusions. |
