

To better understand how the data model and relationships work for Pivot Tables, make sure to read this first. Sales table – Product Key, Customer Number.What connects these tables together are related columns, you will see the following: We have 3 data tables that are related to each other: Product, Customer and Sales The subtotals are now at the bottom of each group, and there is an empty row after each item! Go to Insert > Tables > PivotTableĪnd you will now see the new layout! Products column is in a separate column.

STEP 4: Let us insert a new Pivot Table to see our new default layout! You can explore more options inside PivotTable Options.

