OLAPExpressionBinding Class

Gets or sets an expression that is used to evaluate values for a Pivot Grid’s field in OLAP mode.

Assembly: DevExpress.XtraPivotGrid.v22.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#
VB.NET

public class OLAPExpressionBinding :
    OLAPExpressionBindingBase

Public Class OLAPExpressionBinding
    Inherits OLAPExpressionBindingBase

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 OLAPExpressionBinding to create a calculated field in OLAP mode.

Note

Use ExpressionDataBinding for Optimized and Server modes.

Follow the steps below to create a calculated field in OLAP mode:

Create an OLAPExpressionBinding instance and pass the expression in its constructor as a parameter. You can also use the object’s OLAPExpressionBindingBase.Expression property to specify the expression.
Assign the created object to the PivotGridFieldBase.DataBinding property.

The following code snippet shows how to bind measureField to the MDX expression:

PivotGridField measureField = new PivotGridField() { Caption = "Cleared Amount", 
   Area = PivotArea.DataArea };
measureField.DataBinding = new OLAPExpressionBinding("[Measures].[Internet Sales Amount] * 0.87");
measureField.OLAPDimensionCaption = "Sales";
measureField.Name = "fieldInternetSalesAmount";
pivotGridControl1.Fields.Add(measureField);

Dim measureField As PivotGridField = New PivotGridField() With {.Caption = "Cleared Amount", .Area = PivotArea.DataArea}
measureField.DataBinding = New OLAPExpressionBinding("[Measures].[Internet Sales Amount] * 0.87")
measureField.OLAPDimensionCaption = "Sales"
measureField.Name = "fieldInternetSalesAmount"
pivotGridControl1.Fields.Add(measureField)

View Example

Refer to the following article for more information: Calculated Fields.