Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Grand Total is not correct

Answered
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

Public
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,
Vera

Please login or Register to Submit Answer