Star Gazr1
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.
Book1.xlsx
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER