Hi, I have a pivot where the daily rows need to be summed, however over the month summing doesn't make sense, I'd like the average over the month displayed.
Data Table
Date | Group | Number |
Fri 1 Jul 22 | Group A | 10 |
Fri 1 Jul 22 | Group B | 15 |
Sat 2 Jul 22 | Group A | 5 |
Sat 2 Jul 22 | Group B | 10 |
Resulting Pivot table
The daily rows are correct, summing Groups A & B, however I'd like the Total row to be an Average of the daily figures, so in this case I'd like it to show 20.
Thanks in advance.