Forum Discussion
Is there a way to auto-hide empty columns in a Pivot Table?
I have a massive database and I'm producing a Pivot Table that has over 90 columns, of which many times, less than 20 of them have data, and all other columns are empty. Is there a way to auto-hide t...
In general PivotTable based on data model shall not show fields with no data, however cashed PivotTable shows.
For such sample
let remove data in column B against X and refresh
assuming these PivotTable options are not set