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.