2 Replies Latest reply on Dec 14, 2016 4:24 PM by hetal joshi

    Filter on one table out of two joined tables

    hetal joshi

      Hi,

       

      I have two raw data tables with Visitor Information from three countries for three months

       

      RawDataA: Visiting_Month, Transporation_Mode, Visitor_Name, Country_Name, Visitor_Profession

      RawDataB: Visiting_Month, Transportaion_Mode, Total_Visitor_Count

       

      Joining fields: Visitng_Month, Transportaion_Mode

       

      I want to filter "RawDataA" for only one "Visitor_Profession" (eg: Doctor) but "RawDataB" should not be filtered because it is install base dataset and does not have any dependency on "Visitor_Profession" field from "RawDataA".

       

      When I add "Visitor_Profession" field to Filter, it filters out "RawDataB" fields as well giving incorrect number of total visitors (due to the join).

       

      Any  guidance would be appreciated. Workbook attached.