Pivot table Calculated Field
 

I have a column of Salesmen together with an associated column of their sales.
Let's say that the total of all the sales is £100,000.

I would like to insert a calculated field that shows the % contribution that
each salesman makes to the total sales.

Is this possible in a Pivot table?

Pivot table Calculated Field
 

As answered in microsoft.public.excel.programming:

Instead of a calculated field, you can use a custom calculation:

Add another copy of the Sales Total field to the pivot table's data area
Right-click on a cell in this new column
Click Field Settings, and click the Options button
From the Show Data As dropdown, choose % of Column.
Click OK

RodneyJ wrote:
I have a column of Salesmen together with an associated column of their sales.
Let's say that the total of all the sales is £100,000.

I would like to insert a calculated field that shows the % contribution that
each salesman makes to the total sales.

Is this possible in a Pivot table?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html