TcxPivotGridField.SortOrder Property

Specifies the field‘s sort order.

Declaration

property SortOrder: TcxDataSortOrder read; write; default soNone;

Property Value

Type	Default
TcxDataSortOrder	soNone

Remarks

Data within the pivot grid is always sorted against the column fields and row fields (by default, in no particular order, as provided by the control’s data controller). Use the SortOrder property of these fields to change the current sort order. For other fields, changing the SortOrder property value has no effect on data representation until these fields are placed within the column header area and row header area. End-users can change the sort order by clicking the header of column/row fields, provided that the Sorting property is set to True.

In standard data binding modes, you can handle the pivot grid’s OnCompare event to provide custom sorting logic for field values. In OLAP mode, you can select a sort option for certain dimensions using a dimension SortMode property.