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