1 2 Previous Next 22 Replies Latest reply on Feb 20, 2014 8:30 AM by Devin Brown

    Excluding records that have matching value with another criteria

    Devin Brown

      I use a Tableau extract that contains records that always include a transaction number (e.g. "1234567") and a return status ("Y" = return, "N" = sale). A single transaction number can be found in more than one record, where one could be a sale and then the other could be a return. I need a way to exclude all records where the transaction number is found in a record with return status of "Y". I'm sure there's a way to do this in Tableau but I'm stumped. Any ideas would be greatly appreciated.

        1 2 Previous Next