my data source in around 10K rows. I build a pivot and see that totals in pivot are 95.66 points different from totals from table (=SUM()): 1,161,401 (source) vs 1,161,497(pivot). When I double click the total from pivot, I see that =SUM() on details is correct - 1,161,401. What could be the reason for this? Thanks in advance. Excel 2007

  • you must be leaving out some rows on the pivot table, check you have not filtered anything. other than that the pivot will sum correctly as will the function SUM – PeterH Dec 7 '18 at 13:36

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.