View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Percent (field1/ field2) on pivot table

Here are some more details.
Assume your base data had these headers and ranges:
Year (2000-2005) Reg (Reg1, Reg2)
Type (CCount,STotal) Value (any number)
Then your Pivot Table might looks like this:

Sum of Value Reg Type
Reg1 Reg2
Year CCount STotal ST/CC CCount STotal ST/CC
2000 72 526 7.31 132 904 6.85
2001 84 1285 15.30 49 215 4.39
2002 194 3466 17.87 76 758 9.97
2003 241 3357 13.93 31 988 31.87
2004 46 1458 31.70 67 386 5.76
2005 350 1786 5.10 180 660 3.67

ST/CC are the added fields, so ignore them for the moment.
Click on the cell that says CCount or STotal (not Reg1 or Reg2).
From the Pivot Table tool bar, select

Formula Calculated Item (not Calculated Field)
In the Fields box on the left, select Type.
From the Items box on the right, select STotal and CCount

so the formula will read:
=STotal/CCount
Change the name from Formula1 to ST/CC