Straight Table Expression

[#1]

All,

I have a straight table with one single dimension and 8 expressions. Is there a way i can suppress the values of the dimension if they're "0" in say expression 5 or any expression for example? 

Bad Example, but say this is my straight table. Since "Count" has the two "0" values I want to suppress D and E. Is this possible? Granted the expressions I'm working with are much more extensive.

[sunny_talwar · Accepted solution]

May be this as your calculated dimension:

=If(Aggr(YourExpressionForCount, Name) > 0, Name) and then 'Suppress When Value Is Null' on dimension tab.

[#3]

Yep, that was it. Thanks Sunny!

[sunny_talwar]

Not a problem

Glad we were able to resolve it quickly.

Best,

Sunny