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.

In This Section

• Relationships Overview

• Create a Relationship Between Two Tables

• View and Edit Relationships

• Delete Relationships

• Troubleshoot Relationships

See Also

Concepts

Work with Tables and Columns

Add Calculations to Your Reports, Charts, and PivotTables

Other Resources

Filter and Sort Data in PowerPivot