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/
⋅ 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,
Vera
