Forum

Can not solve the p...
 
Notifications
Clear all

Can not solve the problem in Pivot Table.

2 Posts
2 Users
0 Reactions
74 Views
(@mirjana_jc)
Posts: 1
New Member
Topic starter
 

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?

 
Posted : 28/11/2021 10:11 am
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

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

 
Posted : 28/11/2021 3:21 pm
Share: