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 and sum all the values in the pivot table but I dont get the exact number. Thanks for help
1 Reply
- Riny_van_EekelenPlatinum Contributor
The grand total returns the average of all values, not the sum of daily averages. Does that make sense?