Difference between revisions of "Insert Ranking"
(Created page with 'A simple ranking report containing {{Code|XL3RankLookup}} and {{Code|XL3ValueRankLookup}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|…') |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| Line 1: | Line 1: | ||
| − | A simple ranking report containing {{Code|[[XL3RankLookup]]}} and {{Code|[[XL3ValueRankLookup]]}} formulae can be inserted directly into the spreadsheet using the {{Menu| | + | A simple ranking report containing {{Code|[[XL3RankLookup]]}} and {{Code|[[XL3ValueRankLookup]]}} formulae can be inserted directly into the spreadsheet using the {{Menu|FluenceXL|Insert Formula|Ranking}} ribbon or menu option. |
''To insert a ranking report:'' | ''To insert a ranking report:'' | ||
| − | # Select the {{Menu| | + | # Select the {{Menu|FluenceXL|Insert Formula|Ranking}} ribbon or menu option |
# Choose a location for the report | # Choose a location for the report | ||
# Choose the hierarchy to return a ranking for | # Choose the hierarchy to return a ranking for | ||
Latest revision as of 08:34, 4 July 2023
A simple ranking report containing XL3RankLookup and XL3ValueRankLookup formulae can be inserted directly into the spreadsheet using the FluenceXL > Insert Formula > Ranking ribbon or menu option.
To insert a ranking report:
- Select the FluenceXL > 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 |
