Creating a
PivotTable begins by adding fields to the table. Every table
calculates something: SUM, COUNT, AVERAGE, etc. In this example,
we'll answer the question: what did you sell? 6.
Add Fields to the PivotTable Go to the
PivotTable Field List. Select:
Product. What Do
You See? Look at the new PivotTable on the left side of the
spreadsheet. The Products should be displayed in the PivotTable. Keep
going...
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Add Fields
PivotTable Tools ->Options-> Show-> Field List
|
|
| |
