Editing How to Add a Column in a Pivot Table



To add a column in a pivot table, follow these steps:

1. Open the Excel file that contains the pivot table you want to modify.
2. Click anywhere inside the pivot table to activate the PivotTable Tools contextual tab in the ribbon.
3. Click the "Design" tab on the PivotTable Tools contextual tab.
4. In the "Layout" group, click the "Report Layout" drop-down arrow, and then select "Show in Tabular Form."
5. Click the "Grand Totals" drop-down arrow, and then select "Off for Rows and Columns."
6. Click the location in the pivot table where you want to insert the new column.
7. In the "Values" area of the "PivotTable Field List" pane, drag the field that you want to use as the data source for the new column to the "Columns" area.
8. The new column will appear in the pivot table. You can customize it by selecting the column header and using the "Value Field Settings" dialog box to specify how the data should be summarized or displayed.

That's it! You have now added a new column to your pivot table.