LubinofS
asked on
How to remove blanks from slicers - Excel 2010 -
I've created a pivot table and added some slicers on it, one of them is showing "blank" in it, however I checked my data and made sure not blank cell is in that column. How can I remove it ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Would affect it the fact that I got blank data in other columns that dont have slicer ?
Check the data source range. It is possible it may extend below your actual data and that will cause a blank to show in the pivot values.
To cross check, add the field in question to a "Report Filter" field and drop down the list of values. You will also see the blank value there as well. Think of a slicer as a visual representation of a Report Filter field.
Blank values in other fields will not effect the values show in a slicer.
HTH
Jerry
To cross check, add the field in question to a "Report Filter" field and drop down the list of values. You will also see the blank value there as well. Think of a slicer as a visual representation of a Report Filter field.
Blank values in other fields will not effect the values show in a slicer.
HTH
Jerry
ASKER