Page 702 - Excel 2013 All-in-One For Dummies

684 Sorting and Filtering the Pivot Table Data
for multiple, nonconsecutive entries in a particular field, you hold down the Ctrl key as you click entries in its slicer. To display values of multiple con- secutive values, you click the first entry in its slicer and then hold the Shift key as you click the last entry you want included.
Figure 2-9 shows you the pivot table for the employee data list after I used three slicers to filter it. The first slicer is for the Gender field, where I selected M so that only the records for the men are displayed in the pivot table. The second slicer is for the Dept field, where I clicked the Engineering item to display only the men’s salaries in Engineering. The third and final slicer is for the Location field, where I selected both the San Francisco and Seattle loca- tions (by holding down the Ctrl key as I clicked their buttons in the Location slicer). As a result, the employee data pivot table is now filtered so that you see only the salary totals for the men in the Engineering departments at the San Francisco and Seattle offices.
Figure 2-9:
Employee pivot table showing the men’s salaries
in the Engineering department in San Francisco and Seattle.