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 ...
Get Microsoft® PowerPivot 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.
