Page 477 - Computer Software Application TP - Volume 1
P. 477
COMPUTER SOFTWARE APPLICATION - CITS
2 The PivotTable will include multiple columns. In our example, there is now a column for each region.
Filters
Sometimes you may want focus on just a certain section of your data. Filters can be used to narrow down the data
in your PivotTable, allowing you to view only the information you need.
To add a filter:
In our example, we’ll filter out certain salespeople to determine how they affect the total sales.
1 Drag a field from the Field List to the Filters area. In this example, we’ll use the Salesperson field.
462
CITS : IT & ITES - Computer Software Application - Exercise 75 : IT & ITES - Computer Software Application - Exercise 75
CITS
