Google Answers Logo
View Question
 
Q: Weighted Average in Excep Pivot Tables ( No Answer,   1 Comment )
Question  
Subject: Weighted Average in Excep Pivot Tables
Category: Computers > Software
Asked by: heinzelman-ga
List Price: $10.00
Posted: 17 Mar 2006 13:48 PST
Expires: 12 Apr 2006 20:25 PDT
Question ID: 708529
Hello-

In a Pivot Table, I am trying to create weighted averages at the
category level (i.e. by row field). Example:

I have 10 groups of people that utilize 5 separate sources to produce
a widget, each group perform differently.  At the field (sources)
level an average works fin however, when I want to see the weighted
average of each group, I am stuck on how to complete that part.

Can you help?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Weighted Average in Excep Pivot Tables
From: roxrox-ga on 18 Mar 2006 15:45 PST
 
I am not positive that I am understanding your questin completly, but
I'll at least start since no one else has responded.

Using this link
http://www.beyondtechnology.com/tips011.shtml
Using the example shown on that link, couldn't you just use Column D
for the weighted average, put in the formula in Column D, but you
would the formula would go across your row, not down as shown in the
example. The Heading on Column D would Read Weighted Average, and it
would be for the row.

It might be easier if you simply provided 3 rows of data and then ask
your question again, refering to the data.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy