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, kindly take a sample of the pivot table report and attach please for clarity
pls find attached. I have taken a few lines of the raw data (as the whole file contains more than 800K lines).
Please attach your sample file, not just a picture of your results.
The problem is exactly what the other respondents suspected. Your formula in the "Count" column (Col I) contains text. It uses the SUBSTITUTE function to create a text of the cells in the preceding columns.
What exactly is the result you expect to see in your column I ("Count")?
