View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default % Formula in Pivot Table

As a guess not knowing your data I would say that you want to use a
calculated field. Depending on your version there are different ways to
access the Calculated Field dialog (under formula). Try right clicking a
field in the pivot table. Try the pivot table drop down, ... Once you get the
dialog it is a simple division of the two fields.
--
HTH...

Jim Thomlinson


"Liz" wrote:

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!