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
Best Answer
Right-click the cell where you want to show the average, select Summarize Data By and then click Average.