Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft. All rights reserved.