Pivot Table Data Fields Won't Total

Hello,
I'm trying to create a chart to display 3 categories
(ATM,VRU,WWW). I get the Data from a SQL script which I
then import into an Excel spreadsheet. One of the columns
is numbers and I format the column as "Number" with two
decimal places. When I create the Pivot Table only one of
the criteria fields (ATM)will give me a total. The other
two fields keep amounting to zero. I've even tried to skip
the Pivot Chart and just insert Sub-Totals into the
spreadsheet choosing to insert the total after each change
in criteria type; but still only one type of criteria will
give me a total. Can someone please me an idea of why this
is happening? If more info is needed I will supply it in a
reply post. Any help with this will be greatly
appreciated. Thank you.
Dave