Some Business Unit and Multi-Organisation reports contain sorting options so you can rank your departments, projects or organisations. Sorting options include values such as Income, Net Profit or specific KPIs.

Use the Report Builder to select a template from the following list of supported reports and charts.

Choose a Business Unit Selection or Organisation Group then apply a Sort by option on the dropdown as shown below.

By default the chart series is sorted by the included value with largest value first, however you can optionally Sort chart series by name. This option can be found in the Report Criteria under Display Settings.

Where a report contains Actuals & Budgets the sorting is applied to Actual Values. For example in the image above we are sorting by Expenses. In this case it will sort by Actual, Total Expenses for Jul 2020 - Oct 2020.

Some reports either report on Actuals or Budgets but not both. In this case it will sort on the included value type.

Values are sorted with the largest value first, except in the case where you are sorting by a specific KPI. In this case the KPI Builder includes a Target Type which determines Higher or Lower is better where the better result is displayed first.

If your Business Unit Selection contains a hierarchy of consolidated headers and detail business units then the following logic is applied to create a flat list for sorting.