Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Row labels and Column Labels group the same values together to nest data and display subtotals for different groups. You can use row and column labels to transpose data.

You will note that there is a values label listed under the column labels. This is a row or column label that is automatically generated whenever there are two or more data fields. These represent the labels for the data fields in the table. This label can be either a row label or a column label and cannot be modified.

...

Report Filters, or page fields, provide filtering across the entire PivotTable.

Image Added

Data fields

Data fields are used to summarize and aggregate data values with formulas. The values computed from the data fields make up the majority of the PivotTable.

Image Added

PowerPivot

Slicers