You can insert a simple ranking report containing XL3RankLookup and XL3ValueRankLookup formulas directly into the spreadsheet using the Anaplan XL > Insert Formula > Ranking ribbon or menu option.
To insert a ranking report:
- Select the Anaplan XL > Insert Formula > Ranking ribbon or menu option.
- Select a location for the report.
- Select 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.
- Select OK and the formulas will be inserted.
Additional options
You can specify additional filters 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.
You can select the number of members to return in the ranking.
You can also select these options for the ranking:
| Parameters | Descriptions |
| 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. |
