Define a relationship between two tables in PowerPivot.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 25 - PowerPivot Relationships!
Well hey, chapter 25 is all about PowerPivot, a great new add-in that came from Microsoft, PowerPivot lets us mash up various data sets.
And so I have a couple of different tables here, Sales and Weather.
One of those classical mashups, let's see how sales vary by weather.
When we go over to PowerPivot, say we have our two tables here, Sales and Weather, we want to link these two tables together, we want to relate them, and want to set up a relationship.
Sales has date, weather has date.
Now all of these sales are for one city, so we don't have a secondary key there to worry about.
We could just let PowerPivot do this relating for us in the Pivot table, but instead I'm going to explicitly create this.
I want to relate date and this table, to date in the other table.
I come here to the date header of the first table, will right click and say Create Relationship.
And here we're going to go from sales, column Date, and we want to go to Weather, and because Weather has something called Date, it automatically fills that in for us, click Create, and we now have a link between those two items.
When we create the pivot table now, you'll see that we have all of the items from our Sales table, as well as the items from our Weather table, linked together without any hassles at all.
So, one of the great things about PowerPivot is the ability to take those two sheets that have a common key between them, (unclear) Alright hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 25 - PowerPivot Relationships!
Well hey, chapter 25 is all about PowerPivot, a great new add-in that came from Microsoft, PowerPivot lets us mash up various data sets.
And so I have a couple of different tables here, Sales and Weather.
One of those classical mashups, let's see how sales vary by weather.
When we go over to PowerPivot, say we have our two tables here, Sales and Weather, we want to link these two tables together, we want to relate them, and want to set up a relationship.
Sales has date, weather has date.
Now all of these sales are for one city, so we don't have a secondary key there to worry about.
We could just let PowerPivot do this relating for us in the Pivot table, but instead I'm going to explicitly create this.
I want to relate date and this table, to date in the other table.
I come here to the date header of the first table, will right click and say Create Relationship.
And here we're going to go from sales, column Date, and we want to go to Weather, and because Weather has something called Date, it automatically fills that in for us, click Create, and we now have a link between those two items.
When we create the pivot table now, you'll see that we have all of the items from our Sales table, as well as the items from our Weather table, linked together without any hassles at all.
So, one of the great things about PowerPivot is the ability to take those two sheets that have a common key between them, (unclear) Alright hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
