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: Row | In this example, a window is a combination of Country/Category dimensions. |
Criteria: Column | In this example, a window is a combination of Year/Quarter dimensions. |
Criteria: None, Direction: Across | In this example, a window is the entire pivot table. |
Criteria: None, Direction: Down | In this example, a window is the entire pivot table. |
Criteria: Row | In this example, a window is a combination of the Country/Category and Year dimensions. |
Criteria: Column | In this example, a window is a combination of the Year/Quarter and Country dimensions. |
Criteria: Row | In this example, a window is a combination of Country/Year dimensions. |
Criteria: Row | In this example, a window is a combination of Country/Year dimensions. |