Chapter 5Pivot Tables and Pivot Charts: Overview
This chapter is concerned with looking at pivot reports, that is, pivot tables and pivot charts. The chapter is an overview; a whole book could easily be written about pivot tables in Excel—and another one just on pivot charts! The emphasis here is on creating pivot tables and charts. The most important focus is on how to add data to a pivot report using the PowerPivot Field List. But, once this is done, there are dozens of context menus, drop-down menus, and quite a few ribbons with dozens of buttons. Some of these are explored in this chapter, especially where they are particularly relevant to working with PowerPivot. These menu options and buttons help you organize, control, and format your ...
Get Practical PowerPivot & DAX Formulas for 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.
