0 Replies Latest reply: Apr 17, 2013 10:31 PM by ben lim RSS

    if statement on Dimension

    ben lim

      Hi, I am working on pivot table, on the dimension tab.

       

      Example, my variable in the field consist of A,B,C,D

       

      Therefore, if(myfield = 'A','A','others')

       

      others will tabulate B,C,D for me

       

      However,i would want my 'others' to consist of everything in that variable, say A,B,C,D.

       

      any help is appreciated, thanks