General Information
WinForms Controls
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Office File API
Reporting
Report and Dashboard Server
Dashboard
eXpressApp Framework
eXpress Persistent Objects
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
	Core Library Assemblies
	DevExpress Data Library
	DevExpress Pivot Grid Core Library
		Pivot Grid Expression Syntax
		Optimized Calculation Engine
		Aggr Function
		Window Calculations
			Window Calculations Overview
			Partitioning Criteria
			Creating Window Calculations
			Window Calculation Functions
	Miscellaneous
	API Reference
Tools and Utilities
End-User Documentation

Cross-Platform Core Libraries > DevExpress Pivot Grid Core Library > Creating Window Calculations

View this topic on docs.devexpress.com (Learn more)

Creating Window Calculations

Follow the steps below to create a PivotGrid field that uses a window function to calculate its data.

Switch to the Optimized Mode.
Create a PivotGridField instance and specify the field's caption, location, name, and format.

Create a data binding class instance.

You can choose a predefined binding class instance:

WinForms	WPF	ASP.NET	Description
RunningTotalBinding	RunningTotalBinding	RunningTotalBinding	A cumulative total for the specified source binding across a window.
MovingCalculationBinding	MovingCalculationBinding	MovingCalculationBinding	Uses neighbouring values to calculate a total.
DifferenceBinding	DifferenceBinding	DifferenceBinding	Calculates the difference between values across a window.
PercentOfTotalBinding	PercentOfTotalBinding	PercentOfTotalBinding	A percentage of the total for the specified source binding across a window.
RankBinding	RankBinding	RankBinding	Assigns a rank to each row in a window.

You can also use the WindowExpressionBinding type to specify a custom string as an expression that uses window functions:

WinForms	WPF	ASP.NET	Description
WindowExpressionBinding	WindowExpressionBinding	WindowExpressionBinding	A custom calculation with window functions.

Specify the Partitioning Criteria to define a window and the calculation direction (see CalculationDirection) for certain calculation types.
Assign the data binding instance to the PivotGridFieldBase.DataBinding property.
Add the field to the PivotGridControl.Fields collection.

Note

The complete sample project is available in the DevExpress Demo Center: Code Examples - Optimized Mode - Field Calculation Bindings module in the XtraPivotGrid MainDemo .

pivotGridControl.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;

PivotGridField fieldProductAmount = new PivotGridField()
{
    Area = PivotArea.DataArea,
    Caption = "Product Sales",
    Name = "fProductAmount" 
};

PivotGridField fieldProductAmountRunningTotal = new PivotGridField
{
    Area = PivotArea.DataArea,
    Caption = "Running Total",
    Name = "fRunningTotal" 
};

DataSourceColumnBinding productAmountBinding = new DataSourceColumnBinding("ProductAmount");
//Bind a field to a column in the data source. 
fieldProductAmount.DataBinding = productAmountBinding;
//Calculate a running summary of the column. 
fieldProductAmountRunningTotal.DataBinding = new RunningTotalBinding() {
    Source = productAmountBinding,
    PartitioningCriteria = CalculationPartitioningCriteria.ColumnValue,
    SummaryType = PivotSummaryType.Sum
};

pivotGridControl.Fields.AddRange(new PivotGridField[] {
    fieldProductAmount,
    fieldProductAmountRunningTotal,
});;

pivotGridControl.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized

Dim fieldProductAmount As New PivotGridField()
fieldProductAmount.Area = PivotArea.DataArea
fieldProductAmount.Caption = "Product Sales" 
fieldProductAmount.Name = "fProductAmount" 

Dim fieldProductAmountRunningTotal As New PivotGridField()
fieldProductAmountRunningTotal.Area = PivotArea.DataArea
fieldProductAmountRunningTotal.Caption = "Running Total" 
fieldProductAmountRunningTotal.Name = "fRunningTotal" 

Dim productAmountBinding As New DataSourceColumnBinding("ProductAmount")
'Bind a field to a column in the data source. 
fieldProductAmount.DataBinding = productAmountBinding
'Calculate a running summary on the column. 
Dim runningTotalBinding As New RunningTotalBinding()
runningTotalBinding.Source = productAmountBinding
runningTotalBinding.PartitioningCriteria = CalculationPartitioningCriteria.ColumnValue
runningTotalBinding.SummaryType = PivotSummaryType.Sum
fieldProductAmountRunningTotal.DataBinding = runningTotalBinding

pivotGridControl.Fields.AddRange(New PivotGridField() { fieldProductAmount, fieldProductAmountRunningTotal})

Creating Window Calculations

See Also