Page 473 - Computer Software Application TP - Volume 1
P. 473
COMPUTER SOFTWARE APPLICATION - CITS
4 A blank PivotTable and Field List will appear on a new worksheet.
5 Once you create a PivotTable, you’ll need to decide which fields to add. Each field is simply a column header
from the source data. In the PivotTable Field List, check the box for each field you want to add. In our
example, we want to know the total amount sold by each salesperson, so we’ll check the Salesperson and
Order Amount fields.
6 The selected fields will be added to one of the four areas below the Field List. In our example, the Salesperson
field has been added to the Rows area, while the Order Amount has been added to the Values area.
Alternatively, you can click, hold, and drag a field to the desired area.
458
CITS : IT & ITES - Computer Software Application - Exercise 75
