View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default Adding calculated fields

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 ???
.