Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Relationships Between Tables

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft