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
Problem
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
