XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Axis Ranking

Revision as of 12:03, 13 January 2012 by NMaudgil (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 follow this link:

Retrieved from ‘https://help.xlcubed.com/index.php?title=Axis_Ranking&oldid=5297’