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.
