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