Pivot tables are one of the fastest ways to summarise data, but small mistakes can give totals that look right and are wrong. Watch for these common problems.
Mistakes to avoid
- Not refreshing: a pivot table does not update when the data changes until you refresh it.
- Fixed source range: new rows are left out. Use an Excel Table as the source so it grows automatically.
- Numbers stored as text: they are counted, not summed.
- Blank rows or merged cells in the source: they break grouping.
- Count instead of sum: check the value field setting.
- Dates not grouped as you expect: check that the date column contains real dates.
A quick check
Compare the pivot table grand total with a simple SUM of the source column. If they differ, find out why before you share the report.
Next step: see our data analytics course at ScholarLogic, or book a free demo class. A counsellor will share the fee and the next batch dates.
