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

Declaration

[DefaultValue(true)]
public bool AllowSortBySummary { get; set; }
<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.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to AllowSortBySummary
WinForms Controls PivotGridControl
.OptionsCustomization.AllowSortBySummary
ASP.NET Controls and MVC Extensions ASPxPivotGrid
.OptionsCustomization.AllowSortBySummary
MVCxPivotGrid
.OptionsCustomization.AllowSortBySummary
PivotGridSettings
.OptionsCustomization.AllowSortBySummary
Reporting XRPivotGrid
.OptionsCustomization.AllowSortBySummary

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:

SortBySummaryMenu

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:

SortBySummaryMenu_res

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