Partitioning Criteria

• Oct 25, 2021

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.

| |

Criteria: ColumnValue

|

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

| |

Criteria: None, Direction: AcrossThenDown

|

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

| |

Criteria: None, Direction: DownThenAcross

|

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

| |

Criteria: RowValueAndColumnParentValue

|

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

| |

Criteria: ColumnValueAndRowParentValue

|

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

| |

Criteria: RowAndColumnParentValues, Direction: AcrossThenDown

|

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

| |

Criteria: RowAndColumnParentValues, Direction: DownThenAcross

|

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

|