Excel Pivot Table

[willm22]

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?

[#2]

@willm22 

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.