PivotGridFieldSortBySummaryInfo.Conditions Property
Contains conditions that identify the column or row whose values are sorted.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v23.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
Property Value
| Type | Description |
|---|---|
| PivotGridFieldSortConditionCollection | A PivotGridFieldSortConditionCollection collection whose items identify the column or row of values to be sorted. |
Remarks
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.
Note
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.