5 Replies Latest reply on Nov 22, 2016 6:49 AM by A K

    Modifying pivot by making some changes in data source

    A K

      Hello all,

       

      I have created a workbook with several worksheets and graphs and etc. in Tableau and I am trying using this file to create another workbook which is similar to that, but with new data. The problem is, the new data has more columns with different titles. For example: in first workbook I have a pivot including these columns: MLG11, MLG12 and in second workbook I need to change the header MLG11 to MLG1, MLG12 to MLG2, and also add MLG3. When I modify the Excel file based on my new data and update the database in Tableau, everything would be messed up. The pivot becomes undefined and etc. I don't want to start creating the second workbook from scratch. Any comment or solution is highly appreciated.

       

      Regards,

      Ali