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.

 

Count is the default field value. What are the other options? Keep going...

 

PivotTable Tools ->Options-> Show> Field List

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Values