Multi-level sorting

Multi-level sorting can be performed sequentially for multiple levels. The level determines the order in which the sorting condition and its parameters are applied: sorting criterion (by value, by color), order (ascending/descending, up/down), special parameters for the selected criterion (color, icon).

The data is first sorted by the first level, then the next level of sorting is applied within each group. For example, in the figure 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.