How do I create a calculated field on the Total in a pivot table?

?

??4Pat

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top