We help IT Professionals succeed at work.

Excel 2010 Pivot Table Calculated Fields

132 Views
Last Modified: 2017-03-23
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.
Book1.xlsx
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

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