Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Cool Tricks Native to Pivot Tables

8. Cool Tricks Native to Pivot Tables

In This Chapter

Applying Sorting Rules to Pivot Tables175
Showing the Top Five Customers182
Changing the Calculation in the Pivot Table184
Pivot Table Formatting190
Applying Data Visualizations and Sparklines195


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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint