Hi guys,
I have a pivot table in which my filter in it recognizes some cells with formula in them as if they are data (the cells shows nothing with help of IF and "") hence the slicers include an empty box which does not amount to anything. I want to avoid or remove this box somehow this but could not figure out how. A similar question was asked in the thread below without any answers as of now.
Thank you for your help a bunch!
I have a pivot table in which my filter in it recognizes some cells with formula in them as if they are data (the cells shows nothing with help of IF and "") hence the slicers include an empty box which does not amount to anything. I want to avoid or remove this box somehow this but could not figure out how. A similar question was asked in the thread below without any answers as of now.
Remove Items from Pivot Table Filters or Remove Items from Slicers
Hi guys, I have a pivot table that draws data from a column dynamically. I say dynamically because all the data that is drawn is being constantly updated by some formulas. The problem is when I draw data from these columns pivot table counts the empty cells (with formula but with use of a in...
www.excelforum.com
Thank you for your help a bunch!
