Page 476 - Computer Software Application TP - Volume 1
P. 476
COMPUTER SOFTWARE APPLICATION - CITS
2 Drag a new field from the Field List into the Rows area. In our example, we’ll use the Month field.
3 The PivotTable will adjust-or pivot-to show the new data. In our example, it now shows the total order amount
for each month.
To add columns:
So far, our PivotTable has only shown one column of data at a time. In order to show multiple columns, you’ll need
to add a field to the Columns area.
1 Drag a field from the Field List into the Columns area. In our example, we’ll use the Region field.
461
CITS : IT & ITES - Computer Software Application - Exercise 75
