Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 4Grouping, sorting, and filtering pivot data

In this chapter, you will:

• Use the PivotTable Fields list

• Sort in a pivot table

• Filter a pivot table: an overview

• Use filters for row and column fields

• Filter using the Filters area

• Group and create hierarchies in a pivot table

With Excel 2019, Microsoft has reversed the auto date grouping added to Excel 2016. Removing the feature was a good move, as the feature proved hard to predict. For anyone who loved the auto grouping and the Drill-Down and Drill-Up features, you can re-create them, although it requires a few extra steps. Grouping will be covered last in this chapter.

First, a quick overview of the PivotTable Fields. Then, a detailed look at sorting, filtering, and grouping a pivot ...