Sorting
The PivotGrid supports sorting both in the OLAP and flat data-binding scenarios. To enable the sortable functionality, use the Sortable() method.
The PivotGrid supports sorting by the caption name of the members. The structure of the sort descriptor is similar to the sort option of the kendo.data.DataSource and contains the following options:
-
field—The name of the dimension, for example,[Date].[Calendar]. -
dir—The direction of the sorting.
All inner members of the sorted dimension will be sorted with the same sort dimension.
To sort the PivotGrid rows and columns, click on the fields in the headers, the field menu or use the PivotGrid Configurator.