Ok now I don't have anything showing where an error was before but is there anyway that I can remove the row entirely since it does not apply to my data? Such as suppressing zeros in all rows, is that possible through an excel pivot table?

And I can't format a calculation? Is there any way around this?