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

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

C#
VB.NET

csharp

public string OlapExpression { get; set; }

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#
VB.NET

csharp

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);
}

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

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.