8 Replies Latest reply on Dec 18, 2017 1:55 AM by Matthieu Morin

    Link several excel workbook - overlapping figures issue

    Matthieu Morin

      Dear All,

       

      I have an issue with Tableau as I want to link 3 different files of bank reconciliation and each file have 3 different sheets.

       

      I used Union to link them together with same column title.

       

      All my workbooks and my sheets are sharing Category and Sub-Category.

       

      But when i add my sub-category, some figures are overlapping. It appears when I have for the same category/sub-category credit and debit also but Tableau seems to doesn't manage the calculation.

       

      You will find attached a workbook example.

       

      Thank you very much for your help,

       

      Matt