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