November 27, 2021
Hello,rnI dont know much about Pivot Tables and I have started to create one that I need. I have in columns: name od town, in rows time, and type od costs, and in values- costs.rnSo, I have put subtotals for time, by adding subtotal with right click. rnThis is the problem: I want to have average costs - (costs/number of employees). When I put new field in Pivot it nicely divedies cost with number of empoyees. But in the cell where I want divedied subtotal with number of employees it just makes sum of calculations on the column. How can I solve that?
December 7, 2016
Welcome to MOTH. Please read these forum rules, you will understand why as soon as you start reading it.
Read This First | Forum Rules and Guides | Excel Forum • My Online Training Hub
It is much easier to understand the issue and to provide some good answers if you can upload a sample file.