O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5. Creating and Managing Relationships

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required