Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In a simple chart I would like to hide column only if it contain only null values.
It's easy to hide column with conditionnal expression.
The problem is how to know there is only null values in column.
Any idea?
conditionnal expression :
if(sum(TOTAL Field)=null(),1,0)
Thanks for this answer.
sum(TOTAL Field) returns 0 with only null values.
This works better for me :
<blockquote><pre> if(sum(TOTAL Field)=0,false(),true())
Hi,
The problem is that he want to supress a Column and not a Row. When show zero values in all columns the rows are supress but he want just the column needed to supress.
If your chart is Straigth Table, in properties -> Presentation, have a option to show conditional the column, but in pivot table doesn't exist this parameter.