Pivot Table - Grand Total calculation
Hello, Can someone tell me, what is the Default formula used to calculate Grand total in Pivot table widget. Thanks.
Forum Discussion
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
