In a pivot table, I would like to have the average of the sumed data, and
make the average update automatically when the table size expends.

Qtr Sum of Sales Amount

Qtr1 28,441.99 |
Qtr2 37,738.23 | I want the average of these sums.
Qtr3 2,691.03 |
Qtr4 2,960.13 |

in the pivot table there no function as "average of Qtr sums", so I can make
one manually, but it won't take the new data into acount when the table
expends


Yann