Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to calculate what percentage
I need to calculate what percentage of a reps goal is represented by the
sales dollars some specfic accounts. I am making a pivot chart and i am trying to plug in this calculation. Example. Bob's account are broken down into 4 categories...of these 4 categories the sales dollars represent 25% of the goal apiece. i need a formula I can build into my pivot table to show that. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to calculate what percentage
wouldn't it be easier to add a column to your data source table for these
percentages, and use that in the pivot table? "HeatherMH" wrote in message ... I need to calculate what percentage of a reps goal is represented by the sales dollars some specfic accounts. I am making a pivot chart and i am trying to plug in this calculation. Example. Bob's account are broken down into 4 categories...of these 4 categories the sales dollars represent 25% of the goal apiece. i need a formula I can build into my pivot table to show that. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to calculate what percentage
Yes it would...but I can't get a percentage formula built that we well give
me the data I need. If you have a formula I can use to build that, then it would be appreciated it. "Patrick Molloy" wrote: wouldn't it be easier to add a column to your data source table for these percentages, and use that in the pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate percentage?? | Excel Worksheet Functions | |||
How to calculate a percentage formula with existing data? | Excel Worksheet Functions | |||
Formula to Calculate Compounded Percentage Per Year | Excel Discussion (Misc queries) | |||
Need formula to calculate average monthly percentage of change... | Excel Programming | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions |