Pivot - Automatic add columns

Follow

Anson Chan

• April 30, 2021 14:31

Hello Team,

We have a use case where we are using the Datameer function of Pivoting data, it works well.

The workbook links with an Import and updates the run job.

Under a scenario we have a small issue where there introduce a new column in the pivot table but the pivot table does not include the new column and require human intervention to reclick "Select All".

Is there a method we can employ so this can be automated?

Thanks,

Anson

0

• 

  Anson Chan

  • April 30, 2021 14:31

  adding the picture here for reference

  

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • May 03, 2021 06:46
  • Edited

  Hello Anson.
  
  By the current design, a Pivot Sheet won't be automatically updated when one adds a new column to its source. Thereby, whenever you would like to include a new column in the pivoting results, you should change the Pivot Sheet settings.
  It's like for other Sheet types. On a new Sheet, you reference columns from an existing one. As soon as you add a new column to a source Sheet, the dependant Sheet won't have this column automatically and you should create a reference.

  0

  Comment actions Permalink

Please sign in to leave a comment.