O'Reilly logo

Excel® 2016 Pivot Table Data Crunching by Michael Alexander, 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

4. Grouping, Sorting, and Filtering Pivot Data

With Excel 2016, Microsoft has added some interesting features for grouping, sorting, and filtering pivot tables. When you add a time or date field to a pivot table, Excel 2016 automatically groups the daily dates up to months and quarters—and possibly years. It was possible to do this manually in Excel 2013, but how to do it was difficult to discover.

A related feature is that pivot charts that include the date hierarchy offer a expand and collapse feature.

This chapter covers grouping, ...

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