CHAPTER 1Creating a Pivot Table

Even though you've likely created many PivotTable reports in Microsoft Excel, you sometimes encounter problems while setting them up. Perhaps the layout isn't as flexible as you'd like, or you have trouble connecting to the data source that you want to use. The PivotTable and PivotChart Wizard provides many options as you create the PivotTable report, and you want to understand the effect the different settings have. This chapter discusses the issues you can consider as you plan the PivotTable report, set up the source data, connect to the source, and select the PivotTable options.

1.1. Planning a Pivot Table: Getting Started


You've been asked to create a pivot table from your company's sales data, and ...

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with the O’Reilly learning platform.

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