All docs
V19.2
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.

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: RowValue

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

Pivot_CalculateAlongColumns

Criteria: ColumnValue

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

Pivot_CalculateAlongRows

Criteria: None, Direction: AcrossThenDown

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

Pivot_CalculateAlongColumnsRows

Criteria: None, Direction: DownThenAcross

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

Pivot_CalculateAlongRowsColumns

Criteria: RowValueAndColumnParentValue

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

Pivot_CalculateAlongColumns_Groups

Criteria: ColumnValueAndRowParentValue

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

Pivot_CalculateAlongRows_Groups

Criteria: RowAndColumnParentValues, Direction: AcrossThenDown

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

Pivot_CalculateAlongColumnsRows_Groups

Criteria: RowAndColumnParentValues, Direction: DownThenAcross

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

Pivot_CalculateAlongRowsColumns_Groups