Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum field is zero when using Pivot table
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 . Thanks for your help in advance. --Ying |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum field is zero when using Pivot table
Hi
Check that the values in the %CPU field is numeric. If they are text entries, that would give you a 0 result. -- Regards Roger Govier "Ying" wrote in message ... 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 . Thanks for your help in advance. --Ying |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table Field | Excel Worksheet Functions | |||
Pivot Table Calculated Field- Help | Excel Worksheet Functions |