With this simple relationship, Excel is easily able to create the relationship. If you choose Auto-Detect, Excel will work to create the relationships and you can check the results by pressing the Manage Relationships button or just Close the window. From here you can select Auto-Detect and let Excel guess the relationships between your tables or you can Create them yourself. A notice will appear above the field list saying Relationships between tables may be needed.

Drag the Total field from the Orders table to the Values area.Expand the table to see fields by clicking the arrow next to the table name.

Drag the Name field from the Customers table to the Rows area.

You can delete one of the pivot tables created since you only need one, the data will remain in the Data Model.īuild your pivot table with the Name from the Customers table in the Rows area and Total from the Orders table in the Values area. With either of your pivot tables created, you should see both tables in the PivotTable Fields window from the All view. Repeat these steps for the Customers table.

Mac excel 2013 data tools relationships