2 Replies Latest reply on May 17, 2018 1:37 AM by Zyg D

    Connecting to the same file twice to pivot it differently

    Zyg D

      I am trying to use the same file twice as data source. I need this in order to twice pivot columns to rows. The thing is, when I pivot data in one data source, the same automatically applies to the other... I need to pivot it twice because of different data types in column groups. Is it possible without creating a copy of the file itself and referencing that copy?