View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RodneyJ RodneyJ is offline
external usenet poster
 
Posts: 2
Default 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?