RunningTotalBinding Class
Defines the calculation that aggregates values cumulatively in the window.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v24.1.dll
NuGet Package: DevExpress.Web
Declaration
Remarks
Follow the steps listed below to bind a Pivot Grid field to the result of the Running Total window calculation.
- Create an instance of the
RunningTotalBinding
class with theSource
property set to the DataBindingBase descendant instance. - Specify the window frame and summary type.
- 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.
<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.
Inheritance
See Also