Else Do You See? There are three parts to a
spreadsheet: Labels, Data, and Formulas. In this example the labels
includes Category, Service, Product, Date, Sales Rep and Amount. These
labels will become the fields in the PivotTable.
fields to organize and calculate the rows and columns. These
fields come from the labels in the first row (the header) in the spreadsheet.
the PivotTable Field List on the right side of your screen. How do
the fields compare to your labels?
What If You Don't See It? The
Field List can be turned on or off with the PivotTable Tools. If you
don't see the Field List:
PivotTable Tools ->Options.
Go to Show-> Field List.