2 Replies Latest reply on Sep 24, 2018 4:35 AM by mohammed almukhtar

    How can I join two table without duplication?

    mohammed almukhtar

      Hi,

       

      I trying to make dashboard that visualize company projects (cost, profit, expense) any recommendation for best way to visualize them.

      However, When I start joining Employee Table with Project Table, I am getting duplication for the data that coming from project table, which cause to double the Project income according to number of Employees in that project.

       

      Sample of the Data attached below:

      Sample.xlsx - Google Drive

       

      Capture.PNG

       

      Thank you in advance.