Forum Discussion
LFM123
Jan 14, 2025Copper Contributor
Grand total when using average in value field settings
I have a pivot table that shows average values for each day, using the average in value field settings. At the bottom of the pivot table its grand total. What does it show? I tried to both average an...
Riny_van_Eekelen
Jan 15, 2025Platinum Contributor
The grand total returns the average of all values, not the sum of daily averages. Does that make sense?