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