Excluding particular dimensions

[#1]

Hi

I have a bar chart but I do not want to show particular dimensions because they do not have a Target Grade assigned (see image Original).

So I have used  the following calculated dimension to strip out the dimension which does not have  target grade:

=if( not wildmatch(Procedures,'*Tests of Control*','*CAAT*'),Procedures)

However, instead of removing the dimension completely, it has created a chart column at the very end with a dimension of a "." . See image (New).

I want to get rid of this. Please help.

[swuehl]

Check the option 'Suppress when Value is NULL' on dimension tab of chart properties.

[#3]

Very helpful thank you!