Forum Discussion
Excel Pivot Table
I have a pivot table (see below) and I am looking to make a column that will show the average amount per month in the time frame that I choose. (Ex. If I choose all of 2022, then the return will show...
Try this:
- Add the Amount with - Income field to the Values area a second time.
- In the Value Field Settings dialog for the new field, change the summary function from Sum to Average.