Formula to calculate what percentage

H

HeatherMH

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.
 
P

Patrick Molloy

wouldn't it be easier to add a column to your data source table for these
percentages, and use that in the pivot table?
 
H

HeatherMH

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.
 

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

Top