8. Cool Tricks Native to Pivot Tables

In This Chapter

Applying Sorting Rules to Pivot Tables 175

Showing the Top Five Customers 182

Changing the Calculation in the Pivot Table 184

Pivot Table Formatting 190

Applying Data Visualizations and Sparklines 195

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

Start your free trial