New Member
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?
VIP
Trusted Members
December 7, 2016
Hello Mirjana,
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.
Br,
Anders
1 Guest(s)