Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about the use of a calculated dimension and suppressing when the value is null or '-'. Probably...
=IF(not WildMatch(Vendor,'*Others*'),Vendor)
On the Dimensions tab, check "Suppress When Value is Null"
-Rob