View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Skien Skien is offline
external usenet poster
 
Posts: 1
Default Custom Calculation in a Pivot Table

Below are results from a pivot table. I cannot get the Total to calculate
correctly..
I inserted a calculated field within this pivot table with this formula
Column 1 = Column 3/Column 2, but Total is not right. Any help is
appreciated.


Task Name 1 2 3
A 10% 144 14
B 12% 144 17
C 14% 144 20
D 14% 144 20
Total 49% 144 71


Thanks