View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
??4Pat ??4Pat is offline
external usenet poster
 
Posts: 1
Default How do I create a calculated field on the Total in a pivot table?

How can I create a calculation from the total of a count of a field on a
pivot table? Example: I need to calculate the number of employees for each
process level times a specified amount - 89 x $4.59, 3 x $4.59.
Count of Name - Full
Segment Process Level Total
302 302 89
305 3
302 Total 92

When I attempt to create a formula =counta('Name - Full')*4.59 I get an error.