Hi .. My Pivot Table is not hiding (stop displaying) the "blank" rows after i refresh the pivot table using a slicer.
e.g. I have Months as my filter .. so when I use the slicer to select Jan 1st, the Pivot Table shows me data for Jan only.
But when I select all the months using the slicer, the Pivot Table includes the "blank" row also.
I have checked my data source and there are no blank rows/columns.
Any help is appreciated.
Bookmarks