Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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