Pivot Table values not showing

[llnivy]

I have a pivot table that is not showing the values from the table. It is showing #N/A. I've tried changing the number format on the table to general and the number format on the pivot table to h:mm:ss. That didn't work. I checked for numbers formatted as text and the cells with the formula that have a value of 0 are showing as text.
I am at a loss on how to fix this issue.

 

[etaf]

can you load onto a share - note the data will be available to everyone - so any sensitive data needs removing

if the numbers are formatted as text, excel can still sum, with spaces , text , it will be zero

Book6
	A	B	C	D	E	F	G
1	name	amount
2	A	12			Row Labels	Sum of amount
3	A	12			A	0
4	A	12			B	23
5	B	4			Grand Total	23
6	B	8
7	B	5
8	B	6
9
Sheet1