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 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?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html