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.v19.2.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.

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