Page 161 - Ms Excel Note and Workbook
P. 161
MICROSOFT EXCEL NOTE AND WORKBOOK
6. The selected fields will be added to one of the four areas below. In our example,
the Salesperson field has been added to the Rows area, while Order Amount has been
added to Values. Alternatively, you can drag and drop fields directly into the desired
area.
7. The PivotTable will calculate and summarize the selected fields. In our example, the
PivotTable shows the amount sold by each salesperson.
152 | P a g e
