corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionscustomization-10a0974f.md
Gets or sets whether end-users can sort row field values by column values, and column field values by row values.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(true)]
public bool AllowSortBySummary { get; set; }
<DefaultValue(True)>
Public Property AllowSortBySummary As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | true |
true if end-users can sort field values by other field values; otherwise, false.
|
If the AllowSortBySummary property is set to Default or True , end-users can sort values of row fields or column fields by other columns/rows via a context menu. The context menu is available when right-clicking an innermost column or row header:
In this example, selecting the “Sort ‘Product Name’ by This Column” option sorts values of the Product Name field by values in the clicked column:
To prevent values of an individual column/row field from being sorted by values of rows/columns, set this field’s PivotGridFieldOptions.AllowSortBySummary property to false.
See Also
PivotGridOptionsCustomization Class