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.
|
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.
|
