7 Replies Latest reply on Dec 14, 2017 4:46 AM by Zhouyi Zhang

    Treat all the records, of the same Order No as "E" as long as one record is "E"

    robinson liu

      hi,

       

      Here's an example

       

      I have a Order Number (7 records) with status of E or Blank.

       

        

      Order NoStatus
      201715598907E
      201715598907
      201715598907E
      201715598907
      201715598907
      201715598907E
      201715598907

       

      As long as 1 record has a "E" meaning exception, I want to treat all the records, of the same Order No

      as "E" as well instead of blank (no exception)

       

      How do I accomplish this in Tableau?

       

      Thanks in advance.

       

      rgds,

      robinson