PivotGridFieldOptionsEx.ShowExpressionEditorMenu Property

Gets or sets whether a user can open the Expression Editor dialog for the current field in the context menu.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

[DefaultValue(false)]
public virtual bool ShowExpressionEditorMenu { get; set; }

VB.NET

<DefaultValue(False)>
Public Overridable Property ShowExpressionEditorMenu As Boolean

Property Value

Type	Default	Description
Boolean	false	true if a user can open the Expression Editor dialog for the current field in a context menu; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowExpressionEditorMenu
PivotGridField	.Options .ShowExpressionEditorMenu

Remarks

Pivot Grid allows you to create calculated fields. They do not obtain their values from fields in the data source. Instead, you specify a binding expression. The expression can be a formula or an aggregate function. You can use the following classes to create a calculated field:

• OLAPExpressionBinding
• ExpressionDataBinding

You can allow users to edit or create new custom expressions in the Expression Editor at runtime. To accomplish this, set the ShowExpressionEditorMenu property to true to add the Expression Editor command to the field’s context menu or call the ShowExpressionEditor method to invoke the Expression Editor.

Use the PivotGridOptionsBehavior.ExpressionEditorMode property to specify the Expression Editor’s version.

Note

You cannot use the Expression Editor dialog in OLAP mode.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowExpressionEditorMenu property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-pivot-grid-custom-group-intervals/CS/CustomGroupIntervals/Form1.cs#L32

pivotGridFieldGroups.Caption = "Product Groups";
pivotGridFieldGroups.Options.ShowExpressionEditorMenu = true;
ExpressionDataBinding customInterval = new ExpressionDataBinding("Iif(Substring([fieldProductName], 0, 1) < 'F'," +

winforms-pivot-grid-custom-aggregates/CS/Win_Pivot_CustomAggregates/Form1.cs#L24

    Expression = "FirstValue([ProductName])" };
pivotGridField1.Options.ShowExpressionEditorMenu = true;
pivotGridField1.Options.ShowGrandTotal = false;

VB.NET

winforms-pivot-grid-custom-group-intervals/VB/CustomGroupIntervals/Form1.vb#L31

pivotGridFieldGroups.Caption = "Product Groups"
pivotGridFieldGroups.Options.ShowExpressionEditorMenu = True
Dim customInterval As ExpressionDataBinding = New ExpressionDataBinding("Iif(Substring([fieldProductName], 0, 1) < 'F'," & " 'A-E', Substring([fieldProductName], 0, 1) < 'T', 'F-S', 'T-Z')")

winforms-pivot-grid-custom-aggregates/VB/Win_Pivot_CustomAggregates/Form1.vb#L24

pivotGridField1.DataBinding = New ExpressionDataBinding() With {.Expression = "FirstValue([ProductName])"}
pivotGridField1.Options.ShowExpressionEditorMenu = True
pivotGridField1.Options.ShowGrandTotal = False