Pivot Tables

[Guest]

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]

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 here:

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