O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required