Optimized Calculation Engine

• Jun 24, 2022
• 2 minutes to read

Pivot Grid can operate in Optimized mode that uses the Optimized Calculation Engine. The Optimized Calculation engine boasts new functionality and improved performance.

Set the PivotGridOptionsData.DataProcessingEngine property to DataProcessingEngine.Optimized to switch to Optimized mode:

C#

pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized;

VB.NET

pivotGridControl1.OptionsData.DataProcessingEngine = PivotDataProcessingEngine.Optimized

The following sections illustrate new functionality of Optimized mode:

Intermediate Level Aggregations

Intermediate Level Aggregations use the summary function to calculate values for data obtained from the first specified data source column, group data by subsequent specified columns, and calculate group summaries. You can nest the aggr function to summarize aggregated data in an expression.

Tip

Documentation:

• Intermediate Level Aggregations

Window Calculations

Window calculations use window functions to calculate data across a set of window rows related to the current row. Partitioning criteria are applied to rows to arrange them in partitions (a subset of rows in a data table).

Tip

Documentation:

• Window Calculations Overview
• Partitioning Criteria
• Creating Window Calculations
• Window Calculation Functions

Data Binding API

Pivot Grid uses the Binding API to bind Pivot Grid fields to data. A data binding source can be a column in the data source or a calculated expression. Optimized mode supports all types of bindings listed below.

Column Binding

Allows you to bind a Pivot Grid field to a data column in the data source. The Pivot Grid field obtains its values from a field in the data source.

Expression Binding

Allows you to bind a Pivot Grid field to an expression and display the calculated result. The expression can be a formula or an aggregate function.

Calculation Binding

Allows you to bind a Pivot Grid field to a window calculation and display aggregated values in the window.

Each specified binding object is a DataBindingBase descendant. This object is assigned to the Pivot Grid field’s DataBinding property.

Tip

Documentation:

• Data Binding API

Demos

• Pivot Grid for WinForms - Intermediate Level Aggregations (Optimized Mode) - Filter Sales by Year and Country

• Pivot Grid for WinForms - Calculation Bindings

Examples

• Pivot Grid for WinForms - How to Aggregate Data by the Field’s First Value

• Pivot Grid for WPF - Field Calculation Data Binding

• ASP.NET Web Forms Pivot Grid - Field Calculation Data Binding

• ASP.NET Web Forms Pivot Grid - How to Aggregate Data by the Field’s First Value

Optimized Mode Restrictions

For information about Optimized mode restrictions, refer to the following article: In-Memory Mode Limitations.