Pivot Table - Grand Total calculation

[lak]

Hello,
Can someone tell me,  what is the Default formula used to calculate Grand total in Pivot table widget.
Thanks.

[HamzaJ]

Hello @lak 

The 'default formula' is the formula you used to do the calculation (for example SUM or AVG). It will apply the formula over the entire dataset and calculate , for example, the average.

If you would chose Average as Totals Calculation, it would calculate the average from the numbers in the rows (so an average of an average)

More on this can be found here: https://docs.sisense.com/main/SisenseLinux/pivot.htm?Highlight=totals#GrandTotalsandSubtotals

Hamza

[lak]

Thank you @HamzaJ .👍