Pivot Table Calculated Field

R

RodneyJ

I have a column of salesmen and an associated column of their sales which
totals £100,000. I want to insert a calculated filed that shows the
percentage that each salesman contributes to the £100,000 total.

Is this possible in a Pivot Table?
 
D

Debra Dalgleish

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
 

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

Similar Threads

Pivot table Calculated Field 1
Absolute value 2
Creating a Calculated Field in a Pivot Table for same field 3
Excel 2003 vba hiding totals for some pivot items and not others 3
Pivot Table with Percentages 4
Automatically Update a Pivot Table Field Used as Column / Row 1
match two conditions to return value from pivot table 1
create a calculated field for pivot tables 2

Top