Need to hide the expression column in straight table

[#1]

Hi,

I am facing one issue in straight table is that, I have expression column wherever value is zero, I have to remove that column from straight table.

Could you please guide me.

[surendraj]

Go to Properties-->Presentation-->Click on that column-->Enable(Hide column)

[avinashelite]

Chart Properties >Presentation >hide

or you could go with conditional hide also in the expression tab

[surendraj]

Yes @Avinash

or else

Enable conditional-->False() should also work.

[#5]

Hi,

Not manually, Some times there may be values. whenever zero is there the I need to hide that column automatically.

I think now clear.

In expression conditional part we have wrote already some condition to expression based on selection.

Thanks for reply.

[surendraj]

Then Add another condition like

if(Your expression value >0,True(),False())

[#7]

Hi Surendra,

its working,

Thanks.

But there is a problem in dimension there is null value but I used suppress null value option but above condition how can I remove grouping with dimension.

i.e  for dimension null value we have measure  value so that is calculating, so I need to remove that value from expression.

[surendraj]

i didn't get you...

please elabarate...!!