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.
ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Wayne, thanks very much for your assistance. I really appreciate it!