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

2 Replies

  • dheerajd's avatar
    dheerajd
    Copper 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.

  • 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