Forum Discussion
summarize values by sum in Pivot table not working
working in pivot table and summarize values by sum is not working (the output is "0"), whilst summarizing by count gives an output of "682185"; this as the table is having so many lines.
Any idea how to solve the issue so I have the values by sum?
14 Replies
713326 Values inside a cell should not have space. To close the gap in the cells- Please use "Text to Column" from Data tab in excel. Sum value in pivot table will show "0" only when the value in the cell has blank space as show in my example.
Example: for blank space in a cell.
Do not select "Comma".
- Hello, you're getting zero after Summarizing value By Sum because the field you drag and drop inside the PivotTable Values axis contains "text"... Not number
In the first caption attached, I drop Product Category field that contains text, into the Values axis
In the second caption, when I summarized values by sum, I got zeros all through
So, you need to drop field can contains summable number into the values axis and then you can summarize values by sum.
Kindly let me know if this helps- Hello, kindly verify from the source data whether the column is in fact number; not text values... You can use ISTEXT function..
