Grand Average in place of Grand Total in Pivot Table
75,180
Right-click the cell where you want to show the average, select Summarize Data By and then click Average.
Related videos on Youtube
Author by
G-Man Says 'Reinstate Monica'
Updated on November 27, 2022Comments
-
G-Man Says 'Reinstate Monica' 12 months
In a pivot table I want to change the Grand Total field to Grand Average. For example.
Row Labels Day1 Day2 Day3 GrandTotal 1 10 20 30 60 2 15 25 35 75 3 20 30 40 90
And I want it to be like:
Row Labels Day1 Day2 Day3 GrandTotal 1 10 20 30 20 2 15 25 35 25 3 20 30 40 30
-
Admin over 6 yearsThe 'Average' Selection is greyed out for me. Any idea why?