Excel 2013 Pivot Table Data Crunching

4. Grouping, Sorting, and Filtering Pivot Data

In This Chapter

Grouping Pivot Fields

Using the PivotTable Fields List

Sorting in a Pivot Table

Filtering the Pivot Table: An Overview

Using Filters for Row and Column Fields

Filtering Using the Filters Area

Filtering Using Slicers and Timelines

Some of the excellent new features that Microsoft added to pivot tables filtering in recent versions include the following:

• Slicers provide a visual way to filter data sets. Slicers are far superior to the old Page Filter technology. Yes, they can take up a lot more real estate, but they also vastly improve the multifiltering technology introduced in Excel 2007.

• Timelines are like a visual filter but for dealing with dates. You can filter by day, month, ...