RunningTotalBinding Class

Defines the calculation that aggregates values cumulatively in the window.

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

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#
VB.NET

public class RunningTotalBinding :
    DirectedCalculationBinding

Public Class RunningTotalBinding
    Inherits DirectedCalculationBinding

Remarks

Follow the steps listed below to bind a Pivot Grid field to the result of the calculation in Optimized mode.

Create an instance of the RunningTotalBinding class with the Source property set to the DataBinding descendant instance.
Specify the window frame and summary type.
Assign the RunningTotalBinding instance to the PivotGridField.DataBinding property.

The example below shows how to use RunningTotalBinding to display a cumulative total of the Extended Price field values.

View Example: Pivot Grid Optimized Mode - Field Calculation Data Binding

MainView.xaml

<dxpg:PivotGridControl
<!-- ... -->
    DataProcessingEngine="Optimized"
    <!-- ... -->
    <dxpg:PivotGridControl.Fields>
    <!-- ... -->
        <dxpg:PivotGridField
            Area="DataArea"
            AreaIndex="4"
            Caption="Running Total"
            CellFormat="C"
            Name="fieldRunningTotal">
            <dxpg:PivotGridField.DataBinding>
                <dxpg:RunningTotalBinding PartitioningCriteria="ColumnValue" SummaryType="Sum">
                    <dxpg:RunningTotalBinding.Source>
                        <dxpg:DataSourceColumnBinding ColumnName="Extended Price" />
                    </dxpg:RunningTotalBinding.Source>
                </dxpg:RunningTotalBinding>
            </dxpg:PivotGridField.DataBinding>
        </dxpg:PivotGridField>
        <!-- ... -->
    </dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>