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

Get Excel® 2016 Pivot Table Data Crunching now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.