Insert Ranking

A simple ranking report containing XL3RankLookup and XL3ValueRankLookup formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Ranking ribbon or menu option.

To insert a ranking report:

  1. Select the XLCubed > Insert Formula > Ranking ribbon or menu option
  2. Choose a location for the report
  3. Choose the hierarchy to return a ranking for
  4. Choose the type of selection:
    Rank at level
    Returns a ranking of the members at the selected level
    Rank by selection
    Allows you to choose a custom member selection to include in the report
  5. Click OK and the formulae will be inserted

Additional Options

  • Additional filters can be specified in the grid on the right of the dialog
  • You can choose whether to get the highest or lowest ranked members by selecting Rank from Top or Bottom
  • The number of members to return in the ranking can be chosen
  • Various other options can be selected for the ranking:
Show title A brief summary of the ranking report is displayed
Show headings Displays a heading for each column of the report
Show totals Totals are displayed at the foot of each column
Show percentages A column is added showing the percentage contribution for each row
Show cumulative percentages A column is added showing the cumulative percentage up to that row
Exclude zeros Zero values are excluded from the report
Exclude nulls Null values are excluded from the report

See Also