Difference between revisions of "Axis Ranking"
(Created page with "XLCubed provides two modes of Ranking - Hierarchy Ranking and Axis Ranking. The first is ‘Hierarchy mode’, and is accessed through the Advanced tab on the member selector fo...") |
|||
| Line 3: | Line 3: | ||
The first is ‘Hierarchy mode’, and is accessed through the Advanced tab on the member selector for the relevant hierarchy. In this model, the ranking is contained within the hierarchy itself, so that if you move the hierarchy from rows to columns, the ranking is then applied on columns. The screenshot below shows a grid displaying the top 5 Products for CY2004. On the right, Geography has been added to rows, so that the Product hierarchy is nested within Geography. | The first is ‘Hierarchy mode’, and is accessed through the Advanced tab on the member selector for the relevant hierarchy. In this model, the ranking is contained within the hierarchy itself, so that if you move the hierarchy from rows to columns, the ranking is then applied on columns. The screenshot below shows a grid displaying the top 5 Products for CY2004. On the right, Geography has been added to rows, so that the Product hierarchy is nested within Geography. | ||
| − | For further information on ‘Hierarchy’ Ranking, Filtering and Sorting | + | For further information on ‘Hierarchy’ Ranking, Filtering and Sorting go to: [[Installation|Enable XLCubed Ribbon]] |
Revision as of 12:05, 13 January 2012
XLCubed provides two modes of Ranking - Hierarchy Ranking and Axis Ranking.
The first is ‘Hierarchy mode’, and is accessed through the Advanced tab on the member selector for the relevant hierarchy. In this model, the ranking is contained within the hierarchy itself, so that if you move the hierarchy from rows to columns, the ranking is then applied on columns. The screenshot below shows a grid displaying the top 5 Products for CY2004. On the right, Geography has been added to rows, so that the Product hierarchy is nested within Geography.
For further information on ‘Hierarchy’ Ranking, Filtering and Sorting go to: Enable XLCubed Ribbon
