Say I put into pivot a number of bananas eaten by the monkey, sliced by months and days. How to add a column containing average number of bananas eaten by the monkey over all period of time?
PHP Code:
bananas| avg |
month | day| | |
May | 05 | 2 | 10 |
May | 06 | 0 | 10 |
May | 07 | 3 | 10 |
May | 08 | 1 | 10 |
May | 09 | 4 | 10 |
Sure I can get it by collapsing all months and days - but that's not a solution for me as I need to include into pivot some more values with formula based on this average and individual value.