| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All calculated fields are zero in Povit table
Excel export,
I am trying to calculate the total of CPU utilization for a given time, but I received all zero after using pivot table. The source data looks like below: TIME USER %CPU SZ VSZ 2007/09/18 00:14:15 oracle 0.02 25360 102464 2007/09/18 00:14:15 oracle 0.98 25488 102976 2007/09/18 00:14:15 root 0.02 86 408 2007/09/18 00:14:15 root 1.50 4832 19328 2007/09/18 00:14:15 root 0.02 56 232 2007/09/18 00:14:15 oracle 80.38 25552 103488 2007/09/18 00:16:16 oracle 0.81 25488 102976 2007/09/18 00:16:16 root 0.28 52 228 2007/09/18 00:16:16 oracle 5.21 25232 100928 2007/09/18 00:16:16 oracle 0.94 25488 102976 2007/09/18 00:16:16 oracle 0.78 25488 102976 2007/09/18 00:16:16 oracle 0.94 25488 102976 2007/09/18 00:16:16 oracle 0.91 25488 102976 2007/09/18 00:16:16 oracle 0.89 25488 102976 Can anyone give me some hints where is wrong? Thanks a lot. --Ying |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
All calculated fields are zero in Povit table
Hi
I responded to your post of 28 Sep. Did you test that the values in the %CPU field are numeric and not Text? -- Regards Roger Govier "Ying" wrote in message ... Excel export, I am trying to calculate the total of CPU utilization for a given time, but I received all zero after using pivot table. The source data looks like below: TIME USER %CPU SZ VSZ 2007/09/18 00:14:15 oracle 0.02 25360 102464 2007/09/18 00:14:15 oracle 0.98 25488 102976 2007/09/18 00:14:15 root 0.02 86 408 2007/09/18 00:14:15 root 1.50 4832 19328 2007/09/18 00:14:15 root 0.02 56 232 2007/09/18 00:14:15 oracle 80.38 25552 103488 2007/09/18 00:16:16 oracle 0.81 25488 102976 2007/09/18 00:16:16 root 0.28 52 228 2007/09/18 00:16:16 oracle 5.21 25232 100928 2007/09/18 00:16:16 oracle 0.94 25488 102976 2007/09/18 00:16:16 oracle 0.78 25488 102976 2007/09/18 00:16:16 oracle 0.94 25488 102976 2007/09/18 00:16:16 oracle 0.91 25488 102976 2007/09/18 00:16:16 oracle 0.89 25488 102976 Can anyone give me some hints where is wrong? Thanks a lot. --Ying |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statements in Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
| Can I use IF function in calculated fields in a pivot table? | Excel Worksheet Functions | |||
| Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
| Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) | |||
| HELP: Access table linked to Excel - calculated fields? | Excel Worksheet Functions | |||
Linear Mode
