7 Replies Latest reply on Nov 10, 2016 8:28 PM by Mahfooj Khan

    Showing correct SUM of a table when joined with another table with multiple references

    Frank-Michael Idrees

      Hi Tableau Community,

       

      I'm facing a small issue when it comes to calculating totals for a certain table that is joined to another table which has multiple references. I have to tables (Purchase & Sales) that are linked by a certain Id (see below picture). In need in the VIZ the Number of Sales Orders the Total Sales Amount the total Number of Purchase Orders and the total Purchase amount. The number of Sales Orders I can do by a calculated field "Countd(Sales ID)" while for the sales amount the sum of sales amounts results into 800 which is not correct. How can I in this case exclude the reference to the Purchase Table in order to get the correct sales amount of 600? I tried to solve it via LOD expressions but did not find a proper soulution.

       

      Screen Shot 2016-11-10 at 12.15.33 PM.png