Skip to main content
All docs

OLAPExpressionBinding Class

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.1.dll

NuGet Package: DevExpress.Win.PivotGrid


public class OLAPExpressionBinding :


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.


Use ExpressionDataBinding for Optimized and Server modes.

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

  1. 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.
  2. 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.Name = "fieldInternetSalesAmount";

View Example

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


See Also