Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check on option "Supress Zero ..." on presentation tab in chart properties
Hi,
You're takling about "hidding a row", I just want to hide a column when its values are null.
Regards
Johanna
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 🙂
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
Are you using Version 9? The conditional hide on a column is only available in Version 9.
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
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,