pivot table | Chapter 6 | multiple sheet pivot table

Today in this chapter we are going to understand how to incorporate multiple sheet's data into a pivot table.

We have already created tables with the data of respective sheets.
Order Date data will bind the three sheets together and acts as a primary key in Database structure.

Order Date with Total

Order Date with Region

Order Date with Representatives

Table names are as follows
Table_Region for region
Table_Rep for representatives
Table_Total for Unit and Total column

Download the worksheet here
 

Relationships Diagram under 'Manage Data Model'

We are going to understand the entire procedure with the help of a video. 

Explanations:
Some time the relationship needs to be deleted.
Steps:

• Under the Data Tab.
• Click Manage Data Model.
• Right click on the tab and click Delete.