A calculated column is correct per product but its displayed grand total seems wrong. What should the author examine before changing source data?

1. The calculation and total aggregation rules, especially for ratios or distinct counts
2. Whether the analysis is stored in a shared folder
3. Whether every product name starts with an uppercase letter
4. Whether the browser remembers the previous zoom level