PivotTables need data. When you add Values, you can do calculations.
The following pages will focus on the options at the bottom of the
Field List. Before
You Begin: When you review the
data in the sample spreadsheet, there are a couple of fields that
make sense to use to COUNT or SUM the Values. There are many
Products in each Category. This is a many-to-many relationship.
There is
one Amount for each sale. This a one-to-one relationship. 1. Try
This: Add a Value Go to the
Field List Drag and
Drop Amount to the Values.
(Yes, it may say Count of Amount.
Keep
going...)
PivotTable Tools ->Options-> Show> Field List
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Values
|
|
| |
