Forum Discussion
Adding additional Columns to existing pivot table
Dear All,
I have created a pivot table with certain columns and converted to tabular format view and removed the subtotals.
Now, i want to add additional column "Date" which is not present in source of pivot table, adjacent to tabular format view. After adding the new column, how do i construct the relationship between newly added column and pivot table columns. Could you please let me know how to achieve this.
Thank You in Advance
2 Replies
- dheerajdCopper Contributor
Click anywhere on the Pivot Table.
Hit the PivotTable Analyze tab on the ribbon.
Click on Field List in the Show subsection of the ribbon.
Drag fields between the areas in the PivotTable Fields sidebar panel.
Click Update.
Click anywhere in the pivot table.
Activate the PivotTable Analyze tab of the ribbon.
Click Change Data Source...
Modify the Table/Range to include the new column.
Click OK.