@lomorris,
Take a look at this thread - I think it will solve your problem:
Blank value in slicer and total - #2 by BrianJ