2 Replies Latest reply on Dec 16, 2013 11:10 AM by Matthew McLaughlin

    Calculating the first occurrence of a value in a column

    Matthew McLaughlin

      Morning, all!

       

      Looking to calculate if an item is the first occurrence in certain row.  In Excel, I can easily specify the cell and every cell above it.  In Tableau, I'm lost.

      Clipboard01.png

       

       

      Excel file attached.  Column A contains the item I'm searching for.  Column B returns "True" if that row is the first occurrence in the column.  I later take all rows that are True and use them in another calculation. 

       

      How do I go about recreating this in Tableau?  I'm using v8.1.

       

      Thanks in advance!

       

       

      Matt