Enable condition on Calculated dimension

[tinkerz1]

Hi,

Stuck on calculated dimension in pivot tables, If I use the below formula in a calculated dimension then in an expression I use:

count(distinct [ABC])I will get counts on 2 dimensions

=if(ABC>1,'A','B')

How can I then not show dimension B?

Thanks,

Neil.

[swuehl]

Not sure if I understand what you are trying to achieve, maybe

=if(ABC>1,'A')

edit: And on dimension tab, enable 'Suppress when Value is NULL'