5. Creating and Managing Relationships

In This Chapter

Trying to Autodetect Relationships 85

Manually Defining a Relationship 88

Calculating Between Tables 89

Defining a Difficult Relationship 91

Building a Concatenated Key Relationship 95

Is This Harder than a VLOOKUP 98

Questions About Relationships 98

One of the massive benefits of PowerPivot is the possibility of creating pivot tables from multiple tables. When you have two or more tables, you are going to rely on the concept of relationships to join the tables together.

Good news: Relationships are easier to define than VLOOKUPs are to set up.

Mildly good news: In some simple cases, PowerPivot can autodetect the relationship correctly.

Good news: If you don’t want to rely on automatic ...

Get PowerPivot for the Data Analyst: Microsoft® Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial