5
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
2The 'Average' Selection is greyed out for me. Any idea why? – Martin Duys – 2017-03-03T12:39:30.677