% Formula in Pivot Table

L

Liz

Sum of NET_NEW_ACTIVATIONS 17
Sum of NET_ACTS_QUOTA 116
Sum of NET_ACTS_PERCENT_ACHIEVED #N/A

How would I go about calculating the percentage of 17 / 116?

Any suggestions would be greatly appreciated!
 
L

Liz

Thank you. I have Microsoft office 2003. When I right click on the #N/A where
I want to calculate the percentage between net new activations and net acts
quota where do I go from there? Field Settings - Options, but from there I am
lost.
 
S

Sean Timmons

You would need to go to the Pivot Table toolbar. From there, click on the
word Pivot Table. then, click Formulas, then calculated field.

From there, you can build the formula, activations / quota.
 
Top