Pivot table - not doing sums

Hi there
I have set up a pivot table for some data and although the first fields are fine for some reason the latter ones come up with a blank value when there are values there for it to calculate. No amount of refreshing in this world will make it do anything and I am not sure what is different about those columns compared with the previous ones which are working properly.
Can anyone please help?