Previous Topic

Next Topic

Book Contents

Book Index

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:

Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.