Forum Discussion

shirajstanleyjones's avatar
shirajstanleyjones
Copper Contributor
Oct 18, 2024

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

  • shirajstanleyjones 

    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.

     

Resources