View Single Post
  #1  
Old June 3rd, 2010, 09:12 PM posted to microsoft.public.excel.misc
??4Pat
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.