4. Grouping, Sorting, and Filtering Pivot Data
Some of the excellent new features that Microsoft added to pivot tables filtering in Excel 2010 include the following:
• Slicers provide a visual way to filter data set. 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.
• Sets will someday make an impressive grouping feature in pivot tables. ...
Get Pivot Table Data Crunching: Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
