Multi-level sorting

Multi-level sorting is performed sequentially by several columns (levels), for each of which different sorting criteria can be used.

The data is first sorted by the first level, then the next level of sorting is applied within each group. For example, in the illustration below, multi-level sorting was performed as follows:

1.First, the data was sorted alphabetically by the “Manager” column.

2.Next, for each first-level group (in the example, for manager Ilinskaya), the “Nomenclature” column was sorted in reverse alphabetical order.

3.Finally, for each group in the “Nomenclature” column (in the example, for wood planks) in the “Sales” column, sorting was performed in ascending order of values.

The maximum number of supported sorting levels is 64.