Skip to main content

PivotGridOptionsCustomization.AllowSortBySummary Property

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.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation


public bool AllowSortBySummary { get; set; }

Property Value

Type Description

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