ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create a calculated field on the Total in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/265179-how-do-i-create-calculated-field-total-pivot-table.html)

??4Pat

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.




All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com