pivot table experssion

[srinivasa1]

Hi

Im geeting Zero values is in my pivot table expressions.when i drag the group dimension in to the vertical my expressions is showing zero values which are not related to that perticular group.

How to hide this not related expression for that group.

Thanks in advance.

[Gysbert_Wassenaar]

You can't. The expression is always shown for all values of the dimension. You cannot change that behaviour.

[srinivasa1]

Hi

Thanks for you replay. I have done IT dimension we need to supress Null value, it will work.

[er_mohit]

check on supress zero value in presentation tab..