Pivot Table #VALUE! Error !

T

Tufail

hello,
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.
 
P

Pecoflyer

Hi,
HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity *to add attachments to your posts so you can add workbook
to better illustrate your problems and get help directly with them*
Also if you do join please post in this thread (link found below) s
that people who have been following or helping with this query ca
continue to do so. :

--
Pecoflye

Cheers -

Firefox 3.5.3 is as slow as possible
 
M

Max

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
 
M

Max

You could try a helper col in your source table to trap/convert all of "Sold
Amount" source data to real numbers.
Assume "Sold Amount" is col E, data in E2 down
In F2, copied down: =IF(ISNUMBER(E2+0),E2+0,0)
Label in F1, say: SoldAmt_1
Then just extend the pivot to cover col F, and replace "Sold Amount" with
SoldAmt_1. Any good? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Top