Excel Pivot Table

Occasional Visitor

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?


Screenshot 2022-08-19 153837.png

1 Reply


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.