5. What Do
You See? When you change the Field Settings from Count to Sum the
PivotTable will update the calculations. The example on
this page shows the sales amounts, although the numbers may look odd
because the amounts are not formatted for currency. Do This:
Save Your Spreadsheet Go to
File-> Save. Browse
to your documents folder. File Name:
My Name Customer Sales. Click OK
to save the file.
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Field Settings
PivotTable Tools ->Options-> Active Field->
Field Settings
|
|
| |
