Page 165 - Ms Excel Note and Workbook
P. 165
MICROSOFT EXCEL NOTE AND WORKBOOK
16 DOING MORE WITH PIVOT TABLES
Filters
Sometimes you may want focus on a certain section of your data. Filters can be used to narrow
down the data in your PivotTable, so you can view only the information you need.
To add a filter:
In the example below, we'll filter out certain salespeople to determine how their individual sales are
impacting each region.
1. Drag a field from the Field List to the Filters area. In this example, we'll use
the Salesperson field.
TIP
Filters can help you to find
certain information
156 | P a g e
