Leading the way in Microsoft Office Development

Excel

Step 1 - What are the different Pivot Table Items ?

Step 2 - Row Field

Step 3 - Column Field

Step 4 - Data Area

Notice that the label "Sum of Cost" (in cell "B4") is used to identify the Data Area field as well as the operation, in this case SUM.

Step 5 - Data Field

In this case "Cost" is the Data Field

Step 6 - Items

The values that the Row Field and Column Field contain are also referred to as Items.

Division is the name of the Column Field and its corresponding items (or values) are Marketing, Personnel, Sales and Trading.

Step 7 - Page Field

This allows you to add a third dimension to your pivot table without displaying all the items at the same time.

Step 8 - Grand Totals

Step 9 - Sub Totals

These are only visible when you are using multiple fields in either the row or column areas of your table.

Step 10 - Things to Remember

You can select a field item and all its corresponding data by pressing the left mouse button when the cursor is over the edge of that item. The cursor will change to a black arrow.