Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to hide a pivot table completely(including the headers) if all the values in a dimension are null or missing?
I have tried suppressing the dimension, but the header and borders for one row remain.
Regards,
Santosh
Actually i got it done by adding a formula in the layout tab, to conditionally show the table. Since null values length will always be 1, i set the condition to show th table only if the length is greater than 1.
Hi,
I think you can do that with document actions :
on selection or sheet activation add an action
active object ( = your chart or table)
regards
Actually i got it done by adding a formula in the layout tab, to conditionally show the table. Since null values length will always be 1, i set the condition to show th table only if the length is greater than 1.