Page 484 - Computer Software Application TP - Volume 1
P. 484
COMPUTER SOFTWARE APPLICATION - CITS
2 From the Insert tab, click the PivotTable command.
3 The Create PivotTable dialog box will appear. Choose your settings, then click OK. In our example, we’ll use
Table1 as our source data and place the PivotTable on a new worksheet.
4 The selected fields will be added to one of the four areas below the Field List. In our example, the Order ID
field has been added to the Rows area, while the Total Cost has been added to the Values area. Alternatively,
you can click, hold, and drag a field to the desired area.
469
CITS : IT & ITES - Computer Software Application - Exercise 75
