Only visualize certain values of a dimension in a straight table

[Fquiroga95]

Hi, I have a dimension called Vendor, which has different values. I would like to not visualize "Others" in the Vendor column. So I created a calculated dimension:

=Aggr(ONLY({<Vendor=-{"Others"}>} Vendor),Vendor)

The problem is that is the column is displaying null values, even when I suppressed the null values in "presentation properties".

If I delete the original vendor column, is still displaying null values. 

[BrunPierre]

How about the use of a calculated dimension and suppressing when the value is null or '-'. Probably...

=IF(not WildMatch(Vendor,'*Others*'),Vendor)

[rwunderlich · Accepted solution]

On the Dimensions tab, check "Suppress When Value is Null"

-Rob