9 Replies Latest reply on Nov 19, 2018 8:53 PM by MUHAMMAD MAHMOD

    Calculation in Tableau (CONTAINS Formula)

    MUHAMMAD MAHMOD

      Hi Tableau community

       

      Below is my sample data.

       

      Paper NumbersRoles
      Paper 1Speaker
      Paper 1Chair
      Paper 2Speaker
      Paper 3Chair
      Paper 4Speaker
      Paper 5Speaker
      Paper 6Speaker
      Paper 6Chair

       

      i want to identify which papers that have Speaker AND Chair using CONTAINS Formula.

       

      Appreciate if u can help me