Avatar of fjkaykr11
fjkaykr11
 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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
fjkaykr11

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
fjkaykr11

ASKER
Wayne,  thanks very much for your assistance.  I really appreciate it!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck