Hiding a Pivot Table when all the values in a dimension are null

[sgarim41]

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

[ogautier62]

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

[sgarim41 · Accepted solution]

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.