Link to home
Start Free TrialLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

asked on

Excel 2010 Pivot Table Calculated Fields

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.
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Star Gazr1


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