Forum Discussion
Pivot Table Question
I have the following portion of a pivot table from some Excel data. I would like to take the Month sum value (which is 15 for Jul) and divide by the number of date entries (which is 13 for Jul). Essentially the average number of entries per entry day. Is there a way to create that calculation within the pivot table?
| Jul | 15 | 1.15 |
| 3-Jul | 1 | |
| 5-Jul | 1 | |
| 7-Jul | 1 | |
| 10-Jul | 2 | |
| 11-Jul | 2 | |
| 12-Jul | 1 | |
| 18-Jul | 1 | |
| 20-Jul | 1 | |
| 21-Jul | 1 | |
| 24-Jul | 1 | |
| 25-Jul | 1 | |
| 27-Jul | 1 | |
| 31-Jul | 1 |
In addition, for the global average would you like to have average per entry day within entire period (e.g. year) or average of averages per each month?
