All docs
V19.2
21.1
20.2
20.1
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
A newer version of this page is available. Switch to the current version.

MovingCalculationBinding Class

Defines aggregations across a specified number of values before and/or after the current value.

Namespace: DevExpress.Web.ASPxPivotGrid

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

Declaration

public class MovingCalculationBinding :
    MovingCalculationBindingBase

Remarks

The following code snippet illustrates how to bind a PivotGrid field to the result of the Moving Calculation.

  <dx:PivotGridField ID="MovingCalculation" Area="DataArea" AreaIndex="0"  Name="MovingCalculation">
      <DataBindingSerializable>
          <dx:MovingCalculationBinding PartitioningCriteria="ColumnValue" Direction="AcrossThenDown" SummaryType="Average" PreviousValuesCount="1" 
              NextValuesCount="1" >
              <SourceSerializable>
                  <dx:DataSourceColumnBinding ColumnName="Extended_Price" />
              </SourceSerializable>
              </dx:MovingCalculationBinding>
      </DataBindingSerializable>
      <CellFormat FormatString ="c2" FormatType="Numeric"></CellFormat>
  </dx:PivotGridField>
NOTE

The complete example is available in the GitHub repository: ASP.NET Web Forms Pivot Grid - How to Create Field Calculation Bindings.

For more information, see Data Binding API.

Implements

DevExpress.XtraPivotGrid.IDesignerContextProvider
See Also