if statement on Dimension

[n1ef5ng1]

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