Tutorial Pivot Table. A pivot table is a special excel tool that allows you to summarize and explore data interactively. Select the data to insert a pivot table.
A new sheet will be created with the pivot table tools. If you are sure of the fields to be included in Dynamic pivot tables if you add a new category name to the production.categories table, you need to rewrite your query, which is not ideal.