Forum Discussion

LFM123's avatar
LFM123
Copper Contributor
Jan 14, 2025

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    The grand total returns the average of all values, not the sum of daily averages. Does that make sense?