Tag

PivotGridField.SortMode Property

Specifies the sorting algorithm used to sort field values. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v20.1.dll

Declaration

public FieldSortMode SortMode { get; set; }
Public Property SortMode As FieldSortMode

Property Value

Type Description
FieldSortMode

A FieldSortMode enumeration member that specifies the sorting algorithm.

Remarks

The SortMode property determines the algorithm used to sort field data (by display text, edit value, or the use of a custom sorting algorithm).

To implement a custom sorting algorithm, set the SortMode property to FieldSortMode.Custom and handle the PivotGridControl.CustomFieldSort event.

To sort field values, set the field's PivotGridField.SortOrder property to FieldSortOrder.Ascending or FieldSortOrder.Descending. This arranges the field values in ascending or descending order, according to the algorithm that is specified by the SortMode property.

NOTE

The tree-like (hierarchical) view of the excel filter is available only when the SortMode property equals Value.

See Also