“Column Labels”

“Column Labels” work the same way as “Row Labels”, only that you get an extra column, instead of an extra row when you add fields to “Column Labels” . Quite logical!

Also, we can add multiple fields in the “Column Label” area.

And also with “Column Labels” are fields to be placed on either the “inside” or the “outside”.

Again, there are only totals (subtotals) shown for the different groups of the field which appear on the “outside”.

To add “Column Labels”, click them in the list, and click and drag them to the “Column Labels” area.
Or just click the downward pointing arrow to the right of the field, and select “Column Labels” to move it from the menu.
A third way is to click and drag the label from the list to the area in which you want to place it.

 

Multiple “Row Labels” and “Column Labels”

Before you start clicking and dragging, it might be wise to first think for which data you want to see subtotals. This can save you considerable time afterwards, especially when you start working with real “Pivot Tables”.

So place the fields where you want to see the subtotals at the top of the column and “Row Labels” areas..
You can always move them by clicking and dragging them up or down.

 

“Values”

And finally I add the “Result” field to the “Values” area.

By default, the result value is displayed as “SUM”.

You can change this by clicking the downward pointing arrow button on the right side of the field (1).

This opens the “Value Field Settings” (2) dialog box, from which you can choose from the list: Sum, Count, Average etc. ..

 

Make your choice and click the OK button.

Formatting Numbers has already been discussed in a previous lesson.

 

Multiple “Values”

Sometimes, it may be necessary to include multiple “Values” in our “Pivot Table”.

It is not a problem for “Excel” to set a second value in the list.

 

“Excel” automatically places it in the “Values” area. For each value we can enter a different field setting.

 

Featured Courses

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