2 Replies Latest reply on May 20, 2013 10:51 AM by Jonathan Drummey

    Aggregate after ignoring detail rows? (sum of select distinct)

    Douglas De Couto

      Hi,

       

      I have a data set that combined "master" and "detail" rows.  How can I compute aggregations over only the distinct master records?  In SQL, I would create a subtable with a SELECT DISTINCT, but can't figure this out in Tableau.

       

      See attached Excel data, SQL query that shows what I want, and packaged workbook that shows my vague attempts to get this right.

       

      I've been going through the forums but can't quite get my head around what seem like possible answers.

       

      Thanks for any insight you all can offer.

       

      d