Jul 05 2023 03:54 PM
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
Jul 06 2023 01:25 AM
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