🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Grand Total is not correct

Christopher Phillips asked on December 18, 2019

Hi was just testing in the demo JS Fiddle and I notice the Grand Total was incorrect. I’ve attached screenshots to show what I changed about the pivot
Grand Total Reports 60
Real Total is 65
To be clear this was with the basic Demo fiddle https://jsfiddle.net/flexmonster/rkprvhhs/

1 answer

Vera Didenko Vera Didenko Flexmonster December 19, 2019

Hello, Christopher,
Thank you for writing to us.
We would like to explain that actually the Grand Total is correct: the total distinct record count is 60.

Please see the following example for illustration: https://jsfiddle.net/flexmonster/euvs3x49/
In the provided JSFiddle it may seem that there are 65 distinct records in total because the sum of the subtotals is 65. 
However, please notice that some records are repeated in different groups, for example, $2,962.50 is present for both Apple jam and Corn flakes
When the Grand Total is calculated, this is taken into account and, hence, the actual total count of distinct records is 60.
We hope this helps.
Please let us know if you have any additional questions. 
Best regards,

Please login or Register to Submit Answer