Hi
If I filter the data on my source data, Is it possible to have the pivot table NOT include the hidden rows resulting from the filter on the source data ?
For example: if my source data is 1000 rows and 20 columns and I filter the data based on various conditions across the columns. I want to refresh the Pivot table and have it show results without the hidden rows.
Thanks
JVN
If I filter the data on my source data, Is it possible to have the pivot table NOT include the hidden rows resulting from the filter on the source data ?
For example: if my source data is 1000 rows and 20 columns and I filter the data based on various conditions across the columns. I want to refresh the Pivot table and have it show results without the hidden rows.
Thanks
JVN