Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Manipulate PivotTables (Values)

PivotTable: Field Values So far, this PivotTable has the Products in the Rows. PivotTables also need data. When you add a Field to Values you can do calculations.   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 ->Analyze-> Show> Field List