Pivot Table data incorrect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What could the reason be for a pivot table not showing correct values? For
example, if part of my data includes the values 32, 33, 34, and so on, why
would the the pivot table show the values 1, 1, 1, and so on?
 
What could the reason be for a pivot table not showing correct values? For
example, if part of my data includes the values 32, 33, 34, and so on, why
would the the pivot table show the values 1, 1, 1, and so on?
Click to expand...

With very little to go on, I'll make a stab at a reply.

When you created the pivot table you probably selected entire columns
for the range. For some reason when you do this, Excel includes a row
of all blanks in the data. This causes the default aggregate function
to be count instead of sum.

So check your aggregates and make sure you are summing not counting
 
Back
Top