Pivot Table - average calculations

Graemea

Board Regular
Joined
Oct 30, 2015
Messages
93
Office Version
  1. 365
Platform
  1. Windows
Hi,

In columns B:M I have the sales of a long list of products for each of the 12 months in 2019 in a Pivot Table. So, for example, the Sales for product AAA for January 2019 are in B2 and those for December 2019 are in M2.

Can someone please tell me how to add columns to the Pivot Table that will calculate the average sales for each product to 31/12/2019 for the 3 month and 6 month periods. For example, the 3 month statistic will be calculated using the values for 31/10/2019, 30/11/2019 and 31/12/2019.

Thanks!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,114,509
Messages
5,548,484
Members
410,839
Latest member
MrSumo85
Top