Versions Compared

Key

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

The following steps show how to use the pivot table to preview the data. To see how to generate a pivot table, refer to Creating a Pivot Table for details.).

  1. Drag the fields containing the values you wish to analyze from

...

  1. the Field List into the Data Fields area (shown by the label Drop Data Fields Here).

...

  1. Image Added
  2. As no row or column label fields have been set yet the table will show the summation of the quantity field.

...

  1. Image Added
  2. Drag in the fields containing the row and column labels to the areas

...

  1. marked Drop Row Fields Here and Drop Column Fields Here respectively. The pivot table updates to show these changes.

...

  1. Image Added
  2. Any number of fields can be added to each of the areas. Fields added to

...

  1. the Filter Fields area do not have their values shown in the pivot table but can still be used to filter the data shown.

...

  1. Image Added
  2. To filter the values shown based on a field click the arrow next to the field's name and select the values you want.

...

  1. Clicking (Custom...) allows you to set a filter based on characteristics of the data instead of selecting the specific values.

...

  1. Image Added
  2. Filters can be set on the row and column fields as well.

...

  1. Image Added
  2. The final pivot table is shown below

...

  1. Image Added