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