Insert Ranking
From XLCubedWiki
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:
- Select the XLCubed > Insert Formula > Ranking ribbon or menu option
- Choose a location for the report
- Choose the hierarchy to return a ranking for
- 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
- 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 |
