Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
From the author of Using Automatic Relationship Detection

Using Automatic Relationship Detection

The easiest way to define a relationship is to add a field from the other worksheet into your pivot table. The pivot table results will initially be wrong, and PowerPivot will alert you that a relationship needs to be defined.

Click the Create button. PowerPivot will examine both tables to see if it can figure out a column that both worksheets have in common. In this case, even though Store and StoreID are different headings, PowerPivot noticed that both columns had the same Store Number values and detected the relationship.

This is cool when it works. If it doesn't work, you can resort to explicitly defining the relationship.

  • + Share This
  • 🔖 Save To Your Account