Filtering the Pivot Table Data
The Pivot Table has built in filtering tools that can be used to fine tune the results shown by the Pivot Table.
Filtering data involves using specific criteria to limit what data is displayed by the Pivot Table.
- Click on the down arrow next to the Region heading in the Pivot Table to open the filter's drop down list.
- Click on the check box next to the Select All option to remove the check mark from all the boxes in this list.
- Click on the check boxes next to the East and North options to add check marks to these boxes.
- Click OK.
- The Pivot Table should now show only the order totals for the sales reps that work in the East and North regions.