Comma Training Page 93

PivotTable: Field Headers

Row Labels are Filters. The top row of the PivotTable is the Row Label: This is the Field Header. You can use the Field Header to display all of the products in the PivotTable or just a few.

8. Try This: Filter the Data

Go to Cell A3.
Click on the Row Labels.

Select: Edible Fruit.

Select: Fruit and Veggies.

When you click OK, the PivotTable will display those two products.

Try This, Too: Show All of the Data

Click on the Row Labels:

Select: (Select All)

Click OK.

What If You Don't See It? The Field Headers can be turned on or off with the PivotTable Tools. If you don't see the Field List please try this:

Go to PivotTable Tools ->Options.

Go to Show-> Field Headers.