7. Building Pivot Tables

After completing the preceding chapter, your data has been loaded into PowerPivot and you have added some calculated columns. Now it is time to produce some pivot tables with all of that data.

Depending on your background, you’ve probably built either PivotCache pivot tables or online analytical processing (OLAP) pivot tables. The pivot tables that you create with PowerPivot are a hybrid of both types. Although they are technically OLAP pivot tables, the PowerPivot Field List is going ...

Get PowerPivot for the Data Analyst: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.