8. Cool Tricks Native to Pivot Tables

Excel gurus use a lot of cool tricks with Excel pivot tables. Some of my absolute favorite pivot table tricks don’t work with online analytical processing (OLAP) pivot tables, so they don’t apply to PowerPivot reports. However, there are still plenty of cool tips and tricks in this chapter and the next. If you add just a few of these to your tool chest, you will be running circles around 98% of the people using Excel.

Applying Sorting Rules to Pivot Tables

By default, most fields that you ...

Get PowerPivot for the Data Analyst: Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.