7 Replies Latest reply on Aug 9, 2013 2:35 PM by Kyle Wong

    Is there a way to calculate the times a value in Column A shows up in Column B?

    Kyle Wong

      I'm hoping someone can help me out.

      I'm having trouble trying to create a calculated field (if possible) that counts the number of time Column B shows up in Column C.


      The attached is a sample of my excel data set where I have used the countif function in Column D to get the value I want, but I'd like a calculated field in Tableau to do this.



      ColourID = "016746" shows up twice in Column = "Bin ID"


      End result is to have the counts be adjusted if I choose to filter out a Group (for example, exclude Orange). the example above would yield a count of 0.