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

Partitioning Criteria

Partitioning criteria define a partition (frame) in a data table for window calculations.

The table below lists partitioning criteria used to perform window calculations with the Index window function.

Criteria and Direction

Example

Criteria: CalculationPartitioningCriteria.RowValue

In this example, a window is a combination of Country/Category dimensions.

Criteria: CalculationPartitioningCriteria.ColumnValue

In this example, a window is a combination of Year/Quarter dimensions.

Criteria: CalculationPartitioningCriteria.None, Direction: CalculationDirection.AcrossThenDown

In this example, a window is the entire pivot table.

Criteria: CalculationPartitioningCriteria.None, Direction: CalculationDirection.DownThenAcross

In this example, a window is the entire pivot table.

Criteria: CalculationPartitioningCriteria.RowValueAndColumnParentValue

In this example, a window is a combination of the Country/Category and Year dimensions.

Criteria: CalculationPartitioningCriteria.ColumnValueAndRowParentValue

In this example, a window is a combination of the Year/Quarter and Country dimensions.

Criteria: CalculationPartitioningCriteria.RowAndColumnParentValues, Direction: CalculationDirection.AcrossThenDown

In this example, a window is a combination of Country/Year dimensions.

Criteria: CalculationPartitioningCriteria.RowAndColumnParentValues, Direction: CalculationDirection.DownThenAcross

In this example, a window is a combination of Country/Year dimensions.

Is this topic helpful?​​​​​​​