Group Rank
Description
Returns the relative rank of a value within a numeric column. Often used in conjunction with a Group Summary calculation to perform Top-N rankings.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Rank Largest to Smallest | Checkbox (Default Checked) |
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Literal | ✔ |
Example
Let's say you want to quickly see all of your suppliers ranked by their Amount Vouchered YTD from largest to smallest.
- Open the F0401 report with Address Number (or the associated description - Vendor Name field) grouped and Amount Vouchered YTD.
- Right-click on the Amount Vouchered YTD column and select Quick Calculations > System > Group Rank (This will ensure the ranking is based on the Amount Vouchered YTD totals)
- Once that calculation has completed, right-click on it and select "Sort Ascending" to see your Suppliers listed out from largest amount vouchered to smallest.
Now you are able to see the full list of suppliers ranked based on the unique Amount Vouchered YTD values.
For a more complete use case, please reference the Top N Trend as well, which also utilizes the Group Rank calculation.