Skip to main content

RunningTotalBinding Class

Defines the calculation that aggregates values cumulatively in the window.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v23.2.dll

NuGet Package: DevExpress.Web

Declaration

public class RunningTotalBinding :
    RunningTotalBindingBase

Remarks

Follow the steps listed below to bind a Pivot Grid field to the result of the Running Total window calculation.

  1. Create an instance of the RunningTotalBinding class with the Source property set to the DataBindingBase descendant instance.
  2. Specify the window frame and summary type.
  3. Assign the RunningTotalBinding instance to the PivotGridFieldBase.DataBinding property.

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

View Example

<dx:PivotGridField ID="fieldRunningTotal" Area="DataArea" AreaIndex="4"  Name="fieldRunningTotal" Caption="RunningTotal">
    <DataBindingSerializable>
       <dx:RunningTotalBinding SummaryType="Average"  Direction="AcrossThenDown" PartitioningCriteria="ColumnValueAndRowParentValue">
           <SourceSerializable>
               <dx:DataSourceColumnBinding ColumnName="Extended Price" />
           </SourceSerializable>
       </dx:RunningTotalBinding>
    </DataBindingSerializable>
    <CellFormat FormatString ="c2" FormatType="Numeric"></CellFormat>
</dx:PivotGridField>

See the following topic for more information: Data Binding API.

Implements

DevExpress.XtraPivotGrid.IDesignerContextProvider
See Also