Axis Ranking

XLCubed provides two modes of Ranking: Hierarchy Ranking and Axis Ranking.

For further information on Hierarchy Ranking, Filtering and Sorting go to: 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 apply the ranking.

Where you have two hierarchies on the axis, the result will be the top 5 intersections between the two hierarchies, as shown below.


Applying Axis Ranking

Axis ranking is applied through XLCubed’s right-click menu, and is based from the column header, not from within a specific hierarchy.

Right-click on the column header that you wish to rank (in our example you would right-click on CY 2004) and then select XLCubed > Apply > Ranking > Top x Rows. You can see that Top 10 and Bottom 10 appear as options. If you wish to rank any other count, you can select Top x Rows/ Bottom x Rows and you will be prompted to enter a figure.


You will notice that the first member on the right-hand hierarchy has a little red indicator in the corner:


If you hover over this cell it displays an informational message that the rows are being ranked and that you can right-click to edit the axis or clear the axis ranking.


Clear All: Use this option to clear all axis ranking options.

Edit axis: You will be presented with the window below showing the current ranking setting. You can click the drop-down box to amend this if necessary.


The excluded slices tab allows you to remove certain members from your report.

  • Axis8.png
    Click to add an exclusion list
  • Axis9.png
    Click to Clear All current exclusions

We will add France to our excluded slices list. We select the Geography hierarchy and then in the Selection area choose France. When we click OK France appears in the top half of the window as a member to exclude.


The report is refreshed and you can see that France has been removed from the report.


See Also