O'Reilly logo

Microsoft® PowerPivot for Excel® 2010 by Alberto Ferrari, Marco Russo

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 8. Mastering PivotTables

Now that you are acquainted with the DAX language and Microsoft SQL Server PowerPivot for Excel basics, it is time to move into some advanced topics. In this chapter, you are going to learn in deep detail most of the advanced features of PivotTables.

Some of the features we analyze are not exclusive to PowerPivot—they are Excel features that might be applied to any PivotTable. Nevertheless, we feel that it is very important to see how these features can improve the reporting capabilities of PowerPivot.

Please note that this chapter is quite an advanced one, so we will describe formulas and scenarios taking for granted that the reader has sufficient knowledge of DAX and data models. If, during some scenario, you feel ...

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