There's no calculation to show percent of subtotal. Perhaps you could
put Name1in the row area, and Name in the column area. Then, add a
second copy of Number to the data area, and change it to % of Column, as
shown he
http://www.contextures.com/xlPivot10.html
Amanda wrote:
Hi there
I want to calculate % of subtotals in a Pivot Table - I have a column where
I calculated the % of Total turnover but also want to have the % of subsector
totals.
Name Name1 Sum of Number % of Sector
A A 1 ?
A1 2 ?
A2 3 ?
A Total 6 100%
B B1 1 ?
B2 2 ?
B Total 3 100%
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html