5 Replies Latest reply: May 8, 2016 7:14 AM by Sunny Talwar RSS

    Exclude certain values from a dimension's field

    Shamit Shah

      Hi,

       

      I have the following values in a Dimension called Category:

       

      A

      B

      C

      D

       

      I want to exclude A and B. I tried the expression if(Category<>'A' and 'B',Category) and it did not seem to work.

       

      Any ideas?

       

      Thanks

      Shamit