Pivot - Automatic add columns



  • Anson Chan

    adding the picture here for reference

    Comment actions Permalink
  • Konsta Danyliuk

    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.

    Comment actions Permalink

Please sign in to leave a comment.