sum field is zero when using Pivot table

[Guest]

I hope some one could help me to solve the problem below. I have spent over
one hour trying to solve it, but with no luck.

I have a source data file with fileds of "TIME", "USER", "CPU%" and so on.
The "TIME" field has multiple duplicate time stamps. I want to know how much
CPU utilization consumed by users in each unique time stamp, but I used "sum"
on "CPU%" field, the pivot table gave me zero in the "CPU%" cells.

my source data looks like below:

TIME USER CPU% SZ VSZ
2007/09/18 00:10:15 root 0.02 27 164
2007/09/18 00:10:15 maxsch 0.02 69 328
2007/09/18 00:10:15 maxsch 0.02 69 328
2007/09/18 00:10:15 maxsch 0.02 69 328
2007/09/18 00:10:15 maxsch 0.02 69 328
2007/09/18 00:12:15 oracle 0.83 25488 102976
2007/09/18 00:12:15 oracle 0.02 25488 102976
2007/09/18 00:12:15 root 0.02 31 180
2007/09/18 00:12:15 root 0.02 60 292
2007/09/18 00:12:15 oracle 0.77 25488 102976
2007/09/18 00:12:15 root 0.30 52 228

Where is wrong with my source data? I used data-->external data-->database
query to exact data out from a csv file.

you can send reply back to the chat group or (e-mail address removed).

Thanks for your help in advance.

--Ying

 

[Roger Govier]

Hi

Check that the values in the %CPU field is numeric.
If they are text entries, that would give you a 0 result.