Pivot Table

Copper Contributor



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

1 Reply


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