4. Grouping, Sorting, and Filtering Pivot Data
In This Chapter
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, ...