PivotTable custom calculated total

E

EnviroGirl

I have an Access query that results in a datasheet that
looks like this:

Matrix Detail LabID Analyte Result
mammal Shrew 23 x 4
mammal Shrew 23 y 6
mammal Shrew 23 z 7
mammal Shrew 55 x 12
mammal Shrew 55 y 10
mammal Shrew 55 z 8
mammal mouse 42 x 16
mammal mouse 42 y 13
mammal mouse 42 z 7
mammal mouse 38 x 15
mammal mouse 38 y 5
mammal mouse 38 z 3
worm depur 96 x 18
worm depur 96 y 15
worm depur 96 z 13


I have set up a pivot table with
row fields: Matrix, Detail, LabID
Column field: Analyte
Data: Result
If I click on Result and then the autocalc button I can
easily get calculations for Sum, Average and the other
basic choices but what I would like is to use the button
for "Creat a calculated Total" to calculate something that
is not a choice in the auto calc list like a geometric
mean for example. From all the help I have read it seems
like it should be possible in theory but I can't see to
write an expression for the calculation that does not
result in an error message.

I would be very happy to do this in an Access or Excel
pivot table but it is my impression that custom
calculations for totals are only possible in Access pivot
tables.

Can anyone give me guidance on how to accomplish this type
of custom total calculation?
 
Top