PivotGridField.OlapExpression Property

Gets or sets an expression used to evaluate values for the current unbound field in OLAP. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v20.2.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid

Declaration

C#

public string OlapExpression { get; set; }

VB.NET

Public Property OlapExpression As String

Property Value

Type	Description
String	A string that represents an expression used to evaluate values for the current field in OLAP.

Remarks

The code below shows how to set an unbound expression for OLAP:

C#

using DevExpress.Xpf.PivotGrid;

public MainWindow() {
    // ... 
    var fieldPriceWithDiscount= new PivotGridField() { Caption = "Price with Discount", Area = FieldArea.DataArea }; 

    fieldPriceWithDiscount.OlapExpression = "[Measures].[Internet Standard Product Cost] * 0.9";

    pivotGridControl1.Fields.Add(fieldPriceWithDiscount);
}

VB.NET

Imports DevExpress.Xpf.PivotGrid

Public Sub New()
    ' ... 
    Dim fieldPriceWithDiscount As New PivotGridField() With {.Caption = "Price with Discount", .Area = FieldArea.DataArea}

    fieldPriceWithDiscount.OlapExpression = "[Measures].[Internet Standard Product Cost] * 0.9";

    pivotGridControl1.Fields.Add(fieldPriceWithDiscount)
End Sub

The same unbound expression in XAML:

XAML

    <dxpg:x:Name="fieldPriceWithDiscount" Caption="Price with Discount"  Area="DataArea" AreaIndex="1"
                         OlapExpression="[Measures].[Internet Standard Product Cost] * 0.9" />

Use the PivotGridField.UnboundExpression property to get or set an unbound expression for regular data sources.

To learn more about unbound fields, see Unbound Fields.