Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
73
Views
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
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