To see the percent of each person's total in their team's total, you can
do the following:

In the Pivot table, put salesperson in the row area, and sales team in
the column area.
Put two copies of the Sales field into the data area.
Right-click the heading for one of the Sales fields
Choose Field Settings
From the dropdown list for 'Show data as", select '% of column'
Click OK

fnov wrote:
Would appreciate assistance with Calculated Fields in a Pivot table.

I would like to perform a calculation which invovles a reference to the
total of a field generated in a pivot table.

I would like to calculate the average total sales for a sales team, by
dividing each sales persons total sales, by the teams total sales.

I have tried using the average function, but this only calculates each
individuals average for each sales item.

I cannot work out how to refer to totals generated by pivot tables in a
formula.

Can anyone assist?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html