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



      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.