As I add a new month of data, I want to calculate the average cost for the most recent three months in the pivot table. I want the average column to be the last column in the pivot table. I have attached a sample file.
Thanks in advance
As I add a new month of data, I want to calculate the average cost for the most recent three months in the pivot table. I want the average column to be the last column in the pivot table. I have attached a sample file.
Thanks in advance
Extend your pivot table range to include entire A,B,C columns and deselect blanks.
Then use the below code
See attached. Does this help?Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks