How to Add a Column in a Pivot Table

Step-by-Step Guide

1. 1

   Step 1: Launch Microsoft Excel.

   If the column you want represented in your pivot table does not already exist in the source data worksheet, you will need to insert a column by right clicking on an existing column and choosing "Insert Column" from the popup menu.
   
   If you added a column to your source data, populate that column with the relevant data. ,, Select Change Data Source...
   
   Choose Select a table or range and insert the range of the source data into the Table/Range text box. , The "Refresh" command can be found either on the "Pivot Table Tools" menu or within the Wizard utility. , Alternatively, you can drag the column label into the "Values" section of the pivot table.
   
   Do not drop the column label into the "Columns" section of the pivot table or field list.
   
   This will create a separate column for each original value in the selected source data column. ,
2. 2

   Step 2: Open the file containing the source data and pivot table.

3. 3

   Step 3: Select the tab containing the source data by clicking on it.

4. 4

   Step 4: Make any necessary adjustments to the source data.

5. 5

   Step 5: Click the tab on which your existing pivot table is located and then click inside the pivot table to force the "Pivot Table Tools" menu and the "Field List" to launch.

6. 6

   Step 6: Change the source data to include your newly inserted column

7. 7

   Step 7: if necessary.

8. 8

   Step 8: Refresh the pivot table.

9. 9

   Step 9: Choose the column title for the column you want to add to your pivot table and drag it into the "Values" area of the field list.

10. 10

    Step 10: Alter the summarization type for your new column by right-clicking on the column label in the "Values" section and selecting "Sum

11. 11

    Step 11: " "Count

12. 12

    Step 12: " "Average" or one of the other summarization types

Detailed Guide

About the Author