1 Reply Latest reply on May 18, 2018 8:12 AM by Andrew Watson

    Measure totals too large

    o russell

      Apologies as I can't attach the workbook because of confidentiality.

       

      So, here's the setup:

       

       

      • Sources: A. Master (Excel) B. Target (Excel)
      • Master joined with target (Inner Join)
      • 3 different clauses added to the join
        • Plant
        • Seller
        • product

       

      Q. Totals of the measures are turning out to be too large. A closer inspection of the data shows that Tableau is multiplying/duplicating data. Why is this so and how can I resolve it?

       

      Thanks