Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Formula in Pivot Table
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
% 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Formula in Pivot Table
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. "Jim Thomlinson" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Formula in Pivot Table
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. "Liz" wrote: 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. "Jim Thomlinson" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Formula | Excel Discussion (Misc queries) | |||
Pivot Table Formula | Excel Discussion (Misc queries) | |||
Pivot Table Formula | Excel Discussion (Misc queries) | |||
Pivot Table - if Formula | Excel Worksheet Functions | |||
Add a formula to Pivot Table | Excel Worksheet Functions |