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 the average spent per month for that time frame). The dataset has the transaction by the day/month/year. Is there anyway to show this data?
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.
