For numeric value, I can use "NULL" in MDX to represent zero value. So that,
the item with null value will not be shown in Excel pivot table. But, for
string value, what expression should I use in MDX? I have tried to use " "
before. But, the item is still displayed in pivot table.

Does anybody have suggestion to do?

Thanks!

Polly