7. Building Pivot Tables

In This Chapter

Elements of a Pivot Table 149

Building a Pivot Table 152

Explanation of Column B 162

Two Important Rules with Pivot Tables 166

Working with Pivot Charts 169

Behind the Scenes with PowerPivot Field List and Add-In 172

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® Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial