I have 2 calculated fields in a pivot table, one is a sum
field (Field1) the other a count field (Field2). Can i add
another calculated field based on the values contained in
Field1 & field2. Everything seems to indicate that his is
not possible. Has anyone any ideas on how to do this ???

Could you get outside the pivot table and just write a
regular formula that references Field1 and Field2. It
should work as long as the two fields are always located
in the same location.

Thanks,

Greg
-----Original Message-----
I have 2 calculated fields in a pivot table, one is a sum
field (Field1) the other a count field (Field2). Can i
add
another calculated field based on the values contained in
Field1 & field2. Everything seems to indicate that his is
not possible. Has anyone any ideas on how to do this ???
.