Value Field Settings A PivotTable can use these functions: Sum Count Average Max Min Product Count Numbers StvDev StDevp Var Varp   4. Try This: Choose the Calculation Select Sum from the options. The Custom Name should update to: Sum of Amount.   Click OK and keep going...   Memo to Self: You can summarize the values as a percent of the row, column, group or total. You can also display the values as the difference, % of difference or running total if you wish.   PivotTable Tools ->Analyze-> Active Field-> Field Settings Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use Calculated Fields