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
|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
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
hope this helps