8. Cool Tricks Native to Pivot Tables
In This Chapter
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 ...