Unfortunately, there's no built in calculation to show percent of
subtotal. Perhaps you could change the layout, and put one field in the
column area and one in the row area. Then, in the data area, and
calculate the data field as % of Column, as shown he

http://www.contextures.com/xlPivot10.html

Craig wrote:
I would like to generate percentages as percents of the subtotals within a
pivot table, but have not figured out how to do so. It seems crazy to me
that this would not be a built in feature.


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