Microsoft Office Tutorials and References
In Depth Information
Add Multiple Fields to the Row or Column Area
Add Multiple Fields to the
Row or Column Area
Excel enables you to add multiple fields to the
PivotTable’s row or column area. This is a very
powerful technique because it allows you to
perform further analysis of your data by
viewing the data in an entirely new way.
Adding multiple fields to the row and column
areas enables you to break down your data for
further analysis. For example, suppose you are
analyzing the results of a sales campaign that
ran different promotions in several types of
advertisements. A basic PivotTable might show
you the sales for each Product (the row field)
according to the Advertisement in which the
customer reported seeing the campaign (the
column field). You might also be interested in
seeing, for each product, the breakdown in
sales for each promotion. You can do that by
adding the Promotion field to the row area, as
you see in the example used in this section.
You can use either of the techniques in this
section to add multiple fields to the row area;
you can use the technique on the following
page to add multiple fields to the column area.
Add a Field to the Row
1 Click a cell within the
2 Select the check box of
the text or date field you
want to add.
Excel adds a button for
the field to the Row
Excel adds the field to the
PivotTable’s row area.