Is this Possible

P

pilmart

I have 2 calculatedfields within a pivot table one is a Count of som
values, the other a Sum of some values.

Is it possible to create a third field using these 2 values in some wa
ie adding them, multiplying them etc etc, if so how !!!, cos no matte
how I try I can't seem to get this workingas excel doesn't seem to lik
Calculated values being built from other Calculated values !!!!!

Any help would be wonderful
 
K

Ken Wright

Not sure if I have misunderstood, but I can create two calculated fields eg
calc1 and calc2, and then create a 3rd that refers to calc1+calc2 or
calc1*calc2.

This works fine in 2000 / 2002 / 2003
 
K

Ken Wright

Not sure if I have misunderstood, but I can create two calculated fields eg
calc1 and calc2, and then create a 3rd that refers to calc1+calc2 or
calc1*calc2.

This works fine in 2000 / 2002 / 2003
 
Top