Is this Possible

  • Thread starter Thread starter pilmart
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Calculation 1
I think I need a Pivot Table ,but not sure.... 2
copying and holding certain cells in the function 1
Pivot table and value range 2
PIVOT Display is WRONG 3
sum function 4
Pivot table calculated field Count(field) / sum(field) 0
if condition 2

Back
Top