Get Pivot Table To Ignore Blanks

Hi,

I have a spreedsheet like this

X total X
A 10
B 20
30
C 10

basically the blank is the sum for the week, when I put this into a pivot table it creates a seperate entity called (blank), is there anyway to stop excel showing blank, as it throws off the total.

Thanks

Thanks for the reply, I cant believe I didnt think of it tho! Thanks alot!