Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Manupulate PivotTables (Field Settings) Sum of Amount 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 SAVE to save the file.

PivotTable Tools ->Analyze-> Active Field-> Field Settings