Average column in pivot table or Table

[Anonymous]

I have a pivot table that shows expenses per month. How can I create a column that shows average expenses for the selected period?

EXAMPLE PIVOT TABLE

	2016-Jan	2016-Feb	2016-Mar	TOTALS	AVG
Payee 1	200,00 €	150,00 €		350,00 €	175,00 €
Payee 2		120,00 €		120,00 €	120,00 €
Payee 3	400,00 €		300,00 €	700,00 €	350,00 €

I tried with Aggr() function, but it not consider the months where the value is null

Some advice?

[Lech_Miszkiewicz]

Hi

please refer to my example of dealing with totals (see link).. basicly instead of another total you can create a value for AVG and "voila". I have attached there a working files so you can look at the code

How to add a second total row in straight table?

hope this helps