3 Replies Latest reply on Aug 26, 2016 6:56 AM by Benjamin Greene

    Ability to Drill Through Across Summary and Detailed Data Sources

    Ashwin Chandak

      Hello,

       

      I am trying to achieve a "drill-through" in Tableau across two data sources.

       

      To clarify, here's an example: I have two data sources, say "Department" and "Employees"

       

      In Department you have the following fields, Department ID, Department Name, Number of Employees and

       

      Employees will have the following, Employee ID, Department ID, Department Name, Start Date, Age

       

      Is it possible to create a dashboard/workbook where which has a summary tab of all departments by employees and on clicking any department, we can drill down into the employees with the corresponding data?

       

      The filter and/or parameter selections made on the summary sheet should apply to the other tab .

       

      Any workarounds will be helpful. Thanks.

       

       

       

      -Ashwin