WindowExpressionBinding Class

Specifies a custom string expression with window functions to calculate values. Used as a PivotGrid’s field calculation databinding in Optimized mode.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

public class WindowExpressionBinding :
    DirectedCalculationBinding,
    IExpressionBinding

Public Class WindowExpressionBinding
    Inherits DirectedCalculationBinding
    Implements IExpressionBinding

Remarks

The following example shows how to set up WindowExpressionBinding:

<dxpg:PivotGridControl.Fields>
    <dxpg:PivotGridField
        Area="DataArea"
        AreaIndex="2"
        Caption="Total"
        Name="fieldWindowExpression">
        <dxpg:PivotGridField.DataBinding>
            <dxpg:WindowExpressionBinding
                    Expression="Total(Sum([Extended Price]))" PartitioningCriteria="ColumnValueAndRowParentValue"
                <dxpg:WindowExpressionBinding.Source>
                    <dxpg:DataSourceColumnBinding ColumnName="Extended Price" />
                </dxpg:WindowExpressionBinding.Source>
            </dxpg:WindowExpressionBinding>
        </dxpg:PivotGridField.DataBinding>
    </dxpg:PivotGridField>
</dxpg:PivotGridControl.Fields>

See the following example for more Data Binding usage examples:

View Example: Pivot Grid for WPF - Bind Pivot Grid Fields to Window Calculations

For more information, review the following topic: Optimized Mode and Data Binding API.