Adding PivotTable Fields

To add PivotTable fields:

  1. Under the PivotTable Field List, click the options that you want to add to the PivotTable. In this instance we have clicked the Salesperson, Product Name and Unit Price options. By default, Excel will add textual information to the Row Labels section of the PivotTable and numerical values to the Value section of the PivotTable.
    (Click for larger image)

  2. Once you have added your PivotTable Fields, you are ready to begin manipulating and filtering the data to meet specific requirements.
"Hawthorn Training delivers expert and up to date software training solutions for your business."