Forum Discussion
shirajstanleyjones
Oct 18, 2024Copper Contributor
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
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.