This is about the Workshop pivot table widget. As shown in the images below, an error message sometimes appears (left image), while in other cases, it does not (right image).
I would like to clarify whether the values in the highlighted “Total” row remain consistent regardless of whether this error is displayed.
The reason for my inquiry is that if the total row represents the complete and accurate sum even when an error is shown, it remains a reliable tool for us. However, if the error indicates that some data is missing from the total, we will need to provide a disclaimer to our users.
Could you please advise on how these totals are calculated during such errors?