“Row Labels”

You place a field in the “Row Label” when you want the data from that field to appear in rows of the “Pivot Table”.

How you place the “Row Labels” was explained earlier but for those who have forgotten, simply click the box for the “Gender” field in the field list, and it automatically places the field in the “Row Labels”.

As an example, I place the “Gender” field in the “Row Labels” area.

Our “Pivot Table” has two rows, without the “Grand Total” of course. Man or Woman. The “Gender” label on the top, in this example, is the name of the field. The arrow pointing downward beside the “Filter” button, and next to the label, is used to filter the data in the “Pivot Table”. More on this later.

 

Multiple “Row Labels”

So far we have placed one field in the “Row Labels” area. But we can place as many fields as we want in this area.

 

As an example, I place a second field, “Age” in the “Row Labels” area.

So I click this field in the field list.

“Excel” automatically inserts the second field in the “Row Labels” area below the “Gender” field.

The “Age” field is inserted next to the “Gender” field.

If you include another field, simply select the “Design” tab in the “Pivot Table Tools”, choose “Format” – “Report Format” menu, and click the “Table View” button.

 

 

This places the “Gender” field on the left, or the outside, and the “Age” field on the right, or the inside.

 

Data is first sorted according to the field on the outside, and only second in accordance with the field on the inside.

The moving of the different data in different ways.

Click and drag the upper “Gender” field to include, the “Row Labels” or

1. 2. Click the downwards arrow field next to the name in the “Row Labels” and choose one of the first two options from the drop-down menu.

 

 

 

Note that only totals (subtotals actually) are shown for the different groups of the field on the “outside”. In this example, of course, subtotals may be calculated.
Just so you know, if you determine to see a subtotal on a field, then you must have it facing outwards.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats