Sorting

All the data in the grid is displayed in sorted order, irrespective of the original order in the source table. The sort order is either ascending or descending. Numeric values and date/times are sorted in their natural order, ascending or descending/. Strings are sorted alphabetically, ascending or descending.

Every dimension in the grid can have its own sort order/. For example, rows for the "Category" dimension can have ascending order and those for the "Seller" dimension descending order. The default sort order is ascending for all dimensions.

By default, sorting is in ascending order.

The sort order of a dimension can be set in two ways:

1. Double click on the dimension header.
2. Selecting the measurement context menu item.

The sort order of the dimension is indicated by the corresponding icon.

In the figure, number 1 indicates the sorting direction icon, and number 2 indicates the measurement context menu item.

In addition to the sort order, you can also set the sort type separately for rows and columns. There are three sorting options:

1. By axis values - default sorting.
2. Based on the results of the indicator – sorting is performed according to the total values of the indicator. If there are several indicators, the values of the indicator related to the selected cell are taken for sorting.
3. By active row/column - sorting is similar to the previous sorting method, except that instead of the values of the final row/column, the values of the active (selected in the cross-tab) row/column will be used.

The sort type is selected independently for column and row dimensions using the toolbar.