From the course: SharePoint Advanced: Working with PowerPivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
The advantage of relationships in PowerPivot
From the course: SharePoint Advanced: Working with PowerPivot
The advantage of relationships in PowerPivot
- [Instructor] Now you might be wondering why we went to the trouble of establishing the relations between our different tables. Let's build a simple pivot table using our workbook to demonstrate the reason. So here's my saved workbook, and I've got the PowerPivot tab already open, and we'll start by clicking Manage. We've already added all of the tables into the data model, so it knows everything's here. Click anywhere into any table, and we click the Power Pivot icon. Now, because everything's already added to the data model, it doesn't really matter where you start on this. PowerPivot is going to know that it's looking at all of the tables that have been added to the data model, and it knows your ranges for you. We want to open this up as a new worksheet. So here is a new worksheet. Let's build a Pivot Table, and we'll take Total Sales, and we'll make that the Value, so it's going to add up all of our Total Sales, and I want to see the Total Sales by Salesmen, I'll add Salesmen to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.