Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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