2 Replies Latest reply on Aug 20, 2018 4:46 PM by Padma Yalavarthi

    join two worksheets from one excel doc and trying to use a single filter for dashboard

    Ester Kim

      I am using Excel as my data source. In my excel document I have two worksheets, on excel worksheet 1 I have a column named "Customer" and on excel worksheet 2 I have a column named "Customer Name." I created a join to pull data from both excel worksheets. I created two worksheets in tableau, the first tableau worksheet is using data from excel worksheet 1 and the second tableau worksheet is using data from excel worksheet 2. Is it possible to add a single filter for customer/customer name on my tableau dashboard that will filter through both tableau worksheets?

       

      I looked at the following tableau help page, but since its not a separate data source I don't have the "edit relationship" option - Filter Data Across Multiple Data Sources

       

      Any idea on how could accomplish this?