Microsoft Office Tutorials and References
In Depth Information
Sorting and Filtering Pivot Table Data
As with filtering a Report Filter field, Excel replaces the standard drop-down
button for that column or row field with a cone-shaped filter icon, indicating
that the field is filtered and displaying only some of its summary values in the
pivot table. To redisplay all the values for a filtered column or row field, you
need to click its filter button and then click (Select All) at the top of its
dropdown list. Then click OK.
Figure 9-6 shows the sample pivot table after filtering its Gender Report Filter
field to women and its Dept Column field to Accounting, Administration, and
Human Resources.
In addition to filtering out individual entries in a pivot table, you can also
use the options on the Label Filters and Value Filters continuation menus to
filter groups of entries that don’t meet certain criteria, such as company
locations that don’t start with a particular letter or salaries between $45,000 and
$65,000. For more on using these types of filtering options, see the section
about filtering the records in a data list in Chapter 11.
Slicers in Excel 2013 make it a snap to filter the contents of your pivot table
on more than one field. (They even allow you to connect with fields of other
pivot tables that you’ve created in the workbook.)
Figure 9-6:
Pivot table
after
filtering the
Gender
Report Filter
field and
the Dept
Column
field.
Search JabSto ::




Custom Search