hide a column

[#1]

Hi all,

I have to hide a column when the cells are empty or null.

The formula is

=if(GetFieldSelections(Lib_Analyse,',')='Nb établissements', Sum ({$<[cf_eprd_1]={'CF'}, [cf_eprd_2]={'CF'}>} [es]), 0) so when the result is null on all rows I want to hide the column.

Can you help me.

Thank you

Best regards

Johanna

[sparur]

check on option "Supress Zero ..." on presentation tab in chart properties

[#3]

Hi,

You're takling about "hidding a row", I just want to hide a column when its values are null.

Regards

Johanna

[quwok]

Since you are using expressions, i'll assume you are using a Straight Table.

On the Presentation tab, select the column you like to hide and select 'Conditional'

enter something similiar to the following

= NumericCount(YourColumn) <> 0 or TextCount(YourColumn) <> 0

not sure how efficient this will be on your expression, but i'm sure you get the idea 🙂

[#5]

Thank you.

I am sorry but I have selected the column in the Presentation tab but i don't find "Conditionnal".

Can you explain me where I can find it ?

Thank you

[#6]

Are you using Version 9? The conditional hide on a column is only available in Version 9.

[#7]

Hi,

For straight table it is fine it work . But for pivot table ...where I have my col like this how we can make it work .

Besides in an expression where u have the following cols ..how we can hide/disable an expression :

Volume

Value

COGS

GP = Value-COGS

I want to hide COGS .

rgds

tapas

[#8]

Hi Tapas

You cannot hide a column like this in a pivot table, I don't know of any workaround for this apart from creating two pivot tables, one with the column and one without the column, then you would use a conditional show on each object to control which one is displayed. I'm not sure if this would work for you though.

Regards,