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 ho...
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
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
