|
By
default, the Value was displayed as Count of Amount. In this
example, Amount is money: how much was sold? This data would
make more sense if the Value was displayed as the Sum of the
Amount.
6.
Try it: Edit the Value Field Go to the
PivotTable Field List. Go to the
Values. Select:
Count of Amount. Click on
Value Field Settings... Keep
going...
Memo to Self:
The Field options include:
Move to
Report Filter
Move to
Axis Fields (Categories)
Move to
Legend Fields (Series)
Hide Value
Field Buttons on Chart
Hide All
Field Buttons on Chart
Remove
Field
Value
Field Settings...
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.4. Apply and manipulate PivotCharts:
Edit the Value Field Settings
PivotChart Tools ->Analyze
->Show/Hide->Field List
|
|
| |
