Try a helper col in the source table to trap/convert all data to numbers
Assuming "Sold Amount" data is in E2 down
In F2, copied down: =IF(ISNUMBER(E2+0),E2+0,0)
Put a label in F1, eg: Sold1
Extend your pivot's range to cover col F, then replace "Sold Amount" field
with "Sold1" Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Tufail" wrote:
in my PT #VALUE! error showing under Sold Amount, but not all, there are
about 30~35% this erroe are showing rest are okey, any solutaion ?

thanks in advance.