BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.
- Getting started with PowerPivot for Excel 2010
- Stage 1 - Importing the tables we need
- Stage 2 - Creating a data model
- Stage 3 - Creating a Pivot Table (this blog)
- Stage 4 - creating measures using DAX
- Stage 5 - KPIs in PowerPivot for Excel
Posted by Andy Brown on 31 January 2013
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Stage 3 - Creating a Pivot Table
This is going to be the shortest part of this blog. As for Excel, you can drag fields into the appropriate part of the pivot table:

Here we've put the decade as a vertical slicer, the director's name as a row label and the number of films as the values.
This would give the following pivot table:

Here we're showing only the 1990s films.
I'm assuming that readers of this blog already know what Excel pivot tables are and how to create them!
Now you have a pivot table, it's time to start adding additional measures - which is where the fun starts!
- Getting started with PowerPivot for Excel 2010
- Stage 1 - Importing the tables we need
- Stage 2 - Creating a data model
- Stage 3 - Creating a Pivot Table (this blog)
- Stage 4 - creating measures using DAX
- Stage 5 - KPIs in PowerPivot for Excel