PivotTable: Values 2. What Do You See? When you add the Value, the PivotTable will automatically count the records for each row. There is a Grand Total for all of the Products, too.   This PivotTable Counts the number of sales. For example, there were 11 Banquets sold. Count is the default field value. It might make more sense to use to SUM instead of COUNT for the Values. Where are the options? Keep going...   Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Manipulate PivotTables (Values) PivotTable Tools ->Analyze-> Show> Field List