7 Replies Latest reply on Apr 8, 2016 3:05 PM by Kristen Lund

    Help Needed - Exclude Child Values/Instances in Calculations

    Kristen Lund

      Hello Communities,

       

      I did open a case with Tableau directly, but wanted to try the community aspect as well for some help!

       

      I have a data source that connects multiple tables and at the end, has a double connect - table A inner join table B and table A left join table C. There's a value on table A I am trying to sum, however since an instance of table A can have multiple table C instances, the desired value is being multiplied by the number of instances. How do I basically exclude table C in my calculation without using a new data set? I was thinking something like a sum(if distinct, but I haven't hand any luck. Any suggestions would be greatly appreciated!

       

      Thank you in advance!

      Kristen