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...
Abiola1 thanks for your reply, but this does not make a difference. In the raw data I ahave made sure the data in the columns are seen as numbers (number format).
Any other idea?
Hello, kindly verify from the source data whether the column is in fact number; not text values... You can use ISTEXT function..