ExcelBanter - Pivot Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Tables (https://www.excelbanter.com/excel-worksheet-functions/119816-pivot-tables.html)

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%

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