Let’s take a look.
Let’s start first with the data that goes into a pivot table.
This data is referred to as Source data.
Source data contains rows and columns, and each column represents a Field available in the pivot table.
Now let’s look at the pivot table in this worksheet.
In this window, you’ll see a list of all fields that appear in the Source Data.
Looking at the pivot table itself, we see Grand Totals at the bottom and to the right.
Grand totals can be enabled for rows and columns separately, and they can be disabled completely.
Subtotals can be enabled or disabled for each grouping in a pivot table.
Down the left of the pivot table, you’ll find Row labels.
Across the top of the pivot table are Column labels.
An Item is a special name for the values that appear in Column or Row labels.
A Group is a collection of items displayed as a single item.
A Report Filter is a filter that operates on the entire pivot table.
In this case, the Customer field has been added as a Report Filter.
Finally, Field Headers are labels that identify fields in the pivot table.
They can be enabled or disabled.
