Skip to main content

Sort data

Atoti UI provides the ability to sort your data by a chosen hierarchy or measure.

note

The ability to sort data relies on a series of plugins. If you cannot find them in your application, contact your system administrator.

Sort a table​

To sort a table:

  1. Right-click on the header of the column you want to sort.
  2. Select either Sort ascendingly or Sort descendingly from the context menu.

Once a sort has been applied, there will be an icon in the header of the sorted column. Clicking this icon will change the sort from ascending to descending, or vice versa.

Sort a table

info

Pivot table and Tree table widgets have a non-breaking sort, whereas Table widgets have a breaking sort.

See the Microsoft documentation to learn more about the difference between a breaking and non-breaking sort.

Sort a chart​

To sort a chart:

  1. Right click anywhere on the chart.
  2. Select either Sort ascendingly or Sort descendingly from the context menu.
  3. A second menu will appear where you can select the measure or hierarchy to sort on.

Sort a chart

Remove sort​

The process to remove a sort is the same for all types of widgets.

  1. Right-click anywhere on the widget to open the context menu.
  2. Select Remove sort.

Remove sort on a table

note

The Remove sort menu item only appears if the widget is currently sorted.