Hello,
How to get rid of " (blank) " row or column which is generally added to the pivot table when some blank cells are present in reference data.
I want to remove this " (blank) " row and column even if reference data have blank cells.
Can this be done.
Reason being the location of this " (blank) " cell in Pivot Table row and column changes when reference data is changed and Pivot Table is refreshed. Because of this, layout of the pivot table gets affected and so do the further dependent calculations.
Seeking for help.
Thanks in advance.
Bookmarks