Pivot table shows "0" not the numbers?

[wabewalker]

I have a pivot table that is fired from a micro which works fine but most of the information is represented by a 0.

I know the numbers are there because when a cell holding a 0 is double click a new page is opened showing the correct numbers!??

 

[karenbobby]

Hello,

Please check the following:
1) Is it a formula cell?
2) Is it a correct data type i.e. summing up a "text field" which contains "123" instead of 123?

Good Luck!