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

    IF to exclude values in dimension/table

      Hi

       

      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?

       

      Thanks!