Another improvement is that you can now apply more logical filters to fields that are in the
row or column areas. Whereas previous versions of Excel allowed you to apply the Top 10
AutoShow settings, you can now ask for fields that match a certain pattern, dates that fall in
a certain month, and many other options.
8
Chapter 8Creating and Using Pivot Charts
268
The new filtering features are not compatible with Excel 2003 pivot tables.If you have a pivot table
that was originally created in Excel 2003,Excel assumes that you might want to be able to save the
file with backward compatibility,so it turns off the new features for that pivot table.To ov ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.