Enable condition on Calculated dimension

tinkerz1 — Thu, 02 Jul 2015 13:06:21 GMT

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.

Re: Enable condition on Calculated dimension

swuehl — Thu, 02 Jul 2015 13:08:27 GMT

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'