I have a data set with no blank cells and the format of all cells are numbers. When I try to create a pivot table for it, it by default takes the count of value. When I try to change the value field settings to Sum, the values become 0.
Please help
Tried to create a pivot table to show sum of values but it only shows the count of cells.
When I changed the value field settings to sum, the cell values all become 0