9 Replies Latest reply on Sep 12, 2018 4:00 PM by Monica Van Loon

    How to avoid Data Amplification in inner join ?

    Sandhiya Ramane

      Hi ,

      I m trying to put together a report with two data sources .

      What I am trying to achieve

      Key:Cust ID =Cust ID

      • Look up the Cust Id in the vendor sheet and return me the Cust ID field AND the Vendor Name field for that line item.
      • Count all the distinct account line items per month where the vendor Name is filled in and get a total per month

       

      Problem : Data amplification (attached twbx)

       

      **REVENUE source looks like this for the month of Jan

       

      **Vendor File looks like this

       

      Tableau is throwing me values - I went through forums which spoke about LOD , but I couldn't find my way to fix this issue.