Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amanda Amanda is offline
external usenet poster
 
Posts: 151
Default Pivot Tables

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%