7 Replies Latest reply on Feb 13, 2012 5:21 AM by Alex Kerin

    Distinct sum based on another column

    Gareth Jones

      Hi,

      I have tried searching for this and while I have found similar solutions, unfortunately I have not found anything to help my specific issue.  If there is an answer to this elsewhere, please let me know

       

      OK let's see if I can explain this:

       

       

      Customer Number
      Parent Customer Number
      Parent Customer Sales Volume

      1

      10$50,000
      211$100,000
      399$60,000
      410$50,000
      511$100,000
      688$50,000

       

      Basically, the total unique sum of Parent Customer Sales Volume should equal $260,000.  Parent Customer Number repeats in my set of data, and that is the column I need to sum my Sales Volume based on.

       

      I am running Tableau 7 Personal - using an Access database as my data source.  I am fairly new to this so apoligies in advance for seemingly obvious questions.

       

      Edit: I had thought about adding a new column into my data to identify unique parent customer numbers once with simply a "1", and then sumif based on that value.  I just haven't though about how I could do that just yet, even in excel.

       

      Any help would be much appreciated!

      Gareth