Forum Discussion

Vince2021's avatar
Vince2021
Copper Contributor
Jul 05, 2023

Pivot Table

Hello,

 

I am attempting to create a new pivot table using pre-existing data + new data in a column I created, but the new column will not display as a field. 

 

Any advice? 

 

Thank you

excel

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 06, 2023

    Vince2021 

    If source data is structured table PivotTable shall be expanded on new column automatically.

    If source data is the range which you expanded, use

    to change the source for PivotTable

Resources