That did it. Thanks to both of you for the suggestion. I completely overlooked the fact that to generate the Pivot there is that initial select all. When I tried...

So far I have tried isnull for each of the columns but this has not changed the nulls from the pivot data. I believe the isnull needs to take place...