View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scubadiver scubadiver is offline
external usenet poster
 
Posts: 55
Default Calculated percentage field in a pivot table


This is a part of the pivot table

Year Class average of subtot sum of accounts

2002 1 126631 18759
2 126631 19103
3 126631 59277
4 126631 24416
5 126631 5076


How can I insert a field to get the percentage? I have tried but I get the
wrong answer.

cheers!