5 Replies Latest reply: Dec 11, 2015 3:53 AM by Mavrinder Dhothar RSS

    IF to exclude values in dimension/table



      I am trying to make a pivot table that shows Names according to the below criteria:


      Active = Y (so do not include N values)

      Role = A or B (so do not include C values)

      Type = N or V (so do not include E values)


      The below if statement is what I used in the dimension but I still get values returning that include E values:


      =if(Active='Y' and Role='A' or Role='B' and Type='N' or Type='V', Name)


      Please can anyone assist?