“Column Labels”

The “Column Labels” work the same way as the “Row labels”, the only difference is that we add an extra column in “Column Labels” instead of an extra row in “Row labels”.
We can add multiple fields in the Column Label area also.

And here again the column labels fields can be placed on the “inside” or the “outside”.
Here totals (subtotals) are shown for the different groups of the fields on the “outside”.

To add to column labels, click in the list, and click and drag it to the “Column Label” area.
Or click the downward pointing arrow to the right of the field, and select “Move to Column labels” from the menu.
And the third way is to click and drag the field from the list to the area where you want it.

Multiple “Row Labels” and “Column Labels”

Before you start clicking and dragging, it is wise to think for which data you want to see subtotals. This can save considerable time afterwards.
In this example we have a simple “Pivot Table”.
So put the subtotal fields that you want to see at the top of the column area and row area.
You can always move up or down by clicking and dragging.

Values

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

By default, the value is displayed as Sum.
You can change this default setting by clicking the downward pointing arrow button on the right side of the field.
This opens the “Value Field Settings” dialog box, where you can choose from the list: Sum, Count, Average etc. ..
Make your choice and click the OK button.

We had already seen the “Number format” in Lesson 50

Multiple Values

Sometimes, it may be necessary to include multiple values in our pivot table.
This is not a problem in Excel.
Simply select the second value in the list.
Excel automatically places it in the value 50field.
We can enter a different fieldsetting for each value.

Featured Courses

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