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.2.Core.dll

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

Declaration

C#

[DefaultValue(true)]
public bool AllowSortBySummary { get; set; }

VB.NET

<DefaultValue(True)>
Public Property AllowSortBySummary As Boolean

Property Value

Type	Default	Description
Boolean	true	true if end-users can sort field values by other field values; otherwise, false.

Remarks

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.