Creating Relationships Between Tables
A relationship is a connection that you create between two tables of data. The relationship establishes how the data in the two tables should be correlated. For example, a Customers table and an Orders table can be related in order to show the customer name that is associated with each order. After you have defined a relationship between the tables in the PowerPivot window, you will be able to filter data by using related columns, look up values in related tables, and integrate columns from multiple tables in a PivotTable.
The topics in this section describe how to view and work with relationships.