pivot calculation

  • Thread starter Thread starter boris
  • Start date Start date
B

boris

posted this yesterday, but maybe it was missed. Any help
would be appreciated.

need to do an average of a calculated field, as opposed
to the default sum that it wants to do. All other
options under the field settings are greyed.
 
The field takes two numbers and divides them. I simply
need the table to give me the average of all these
results. A sample list is:

5 10 A/B=.5
10 20 A/B=.5
30 40 A/B=.75
50 60 A/B=.833

I need the average of the formula in the table to
yield .645, which is the average of the divisions. If I
do the sum of A over sum of B (the sum being the only
function that is not greyed out in the field settings),
this does not do the trick (.73). If I do Average A over
Average B, this gives me the same result. So what I am
looking for is ideally, the ability to do a formula in
the calculated field that takes A/B. Then I would like
the field settings to allow me to take the average of
these divisions.
 
I'm also looking for "complex" calculation ( i.e.
percentile ) ... I believe to solve your problem you would
have to makke the A/B outside the pivot table...
 
Back
Top