Forum

Calculation of unit...
 
Notifications
Clear all

Calculation of unit costs in Pivot table for non-related objects

2 Posts
2 Users
0 Reactions
73 Views
(@ulf-h)
Posts: 1
New Member
Topic starter
 

Dear All,

I'd like to understand if there's an option in the Pivot table to calculate unit costs for objects that are not related - pls see attached example.

Imagine you have conversion costs on different cost centers or raw material costs and production volume that are not assigned to these objects - is there a way to calculate the unit costs in a Pivot?

 

Thank you very much.

 

Kind regards, Ulf

 
Posted : 11/12/2020 1:40 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Ulf,

If you load the data into Power Pivot you can write a DAX measure to do this, see example attached.

Mynda

 
Posted : 11/12/2020 8:05 pm
Share: