Sorting is an important requirement when it comes to data analysis. Sorting helps in listing or arranging data in a specified order. The FlexPivotGrid control allows users to sort numeric values in ascending or descending data.

By default, data appearing in output grids are sorted by key. For example, the Country column in the FlexPivotGrid control appears sorted alphabetically. However, this is not always very useful for data presentation as users may prefer to sort the grid by value fields such as Unit Price, Extended Price or Discount.

To enable sorting, the C1FlexPivotGrid.AllowSorting property can be set true. This allows users to sort data by clicking the arrow appearing on the column headers, just like a regular grid. See the image below to visualize this behavior at runtime.