WindowExpressionBinding Class
Defines the calculation that uses a custom string expression with window functions.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.XtraPivotGrid.v21.1.dll
NuGet Packages: DevExpress.Win.Design, DevExpress.Win.PivotGrid
Declaration
Remarks
To bind a PivotGrid field to the result of the calculation, follow the steps listed below.
- Create an instance of the WindowExpressionBinding class.
- Specify the expression, window frame and direction. The default expression is “Index()” that is the Index window function.
- Assign the WindowExpressionBinding instance to the PivotGridField.DataBinding property.
Example
The following code snippet illustrates the use of the Data Binding API:
pivotGridControl.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;
PivotGridField fieldWindowExpression = new PivotGridField()
{
Area = PivotArea.DataArea,
Caption = "Index",
Name = "fWindowExpression"
};
fieldWindowExpression.DataBinding = new WindowExpressionBinding()
{
PartitioningCriteria = CalculationPartitioningCriteria.ColumnValueAndRowParentValue
};
pivotGridControl.Fields.Add(fieldWindowExpression);
Inheritance
See Also