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.




      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!