Use Slots
These options appear when your pivot column is a numeric or date column. In this case, you may not want columns in your Pivot table for every single value of the pivot column. Instead, you may want to specify a range of values to use. The following shows an example of this.
This example summarises the Order_Details table. It shows, for each part, how many orders are for 0-5 parts, how many are for 6-10 parts etc.
Note that:
- when a column has (for instance) >5 to 10, this means greater than 5, and less than or equal to 10.
- if you have selected the checkbox include end slot, AQT will add a column for values greater than the last slot you have specified (this is the >40 column in the example below).
- if your Pivot column contains null values, you may wish to check the include NULL slot checkbox. AQT will include a slot which contains the results for Null values of the pivot column.
- you can use this feature with numeric and date columns only. It should not be used with Timestamp or Time columns.