O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required