Excel 2010 Pivot Table Calculated Fields

fjkaykr11 used Ask the Experts™
Attached is a sample Excel file.   The Pivot WorkSheet has two Pivot Tables.  That obtains the data from the Data Worksheet. The Pivot Table on the Top has a Sum of Product 1 and Product 2 as well as a Calculated Field that totals both products by Region.  The Bottom Pivot Table is a repeat except it provides an Average rather than a Sum.  I am not sure how to create a Calculated field formula in D14 that will provide an Average of Product 1 and 2 .  I realize there methods to do this without a Calculated field but the spreadsheet I am working which I can't upload requires that I work with Calculated fields providing an Average.  Any assistance is greatly appreciated.  Thanks.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
1. Click the bottom Pivot Table
2. In the Options tab on the Ribbon, click Formulas > Calculated Field
3. Enter an appropriate name
4. Enter the formula =AVERAGE( 'Product 1 Sold', 'Product 2 Sold')
4. Click OK

The calculated field will automatically be added to your table.


Wayne,  thanks very much for your assistance.  I really appreciate it!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial