Skip to main content

PivotGridFieldSortBySummaryInfo.Conditions Property

Contains conditions that identify the column or row whose values are sorted.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public PivotGridFieldSortConditionCollection Conditions { get; }

Property Value

Type Description

A PivotGridFieldSortConditionCollection collection whose items identify the column or row of values to be sorted.


If the Conditions property contains no items, values of the current column field or row field are sorted by grand total values. Otherwise, if the Conditions property contains items that identify a particular column or row, values of the current field are sorted by this column/row.

See How to: Sort Data by Columns (Rows) in Code, for an example.


When the data processing engine is in the PivotDataProcessingEngine.LegacyOptimized mode (default value), sorting by summary is not applied if any condition points to a missing value (null). The Legacy data processing engine sorts the data by the Grand Total column in that situation. You can enable this mode by setting the PivotGridOptionsData.DataProcessingEngine property to PivotDataProcessingEngine.Legacy. Note that we consider the legacy behavior incorrect. If you want to sort by the Grand Total column you should not add any conditions at all.

See Also