Tough One: Calculate Share Of Current Shipment Based on Values from Another Table

[Anonymous]

Hi, guys! 

I have a problem I can't solve myself for a week now, so I'm requesting your help 🙂

Here is how my dataset is built:

So in the last table I have all my costs on production calculated by category. So I have 1 value per category.

I need to calculate each shipment share from total in month by category and that's what I cant do as category's values are in another table.

Here is the final formula of profit I want to get:

$ - $ / Total_$(category) * Money Spent On Production

Thanks in advance! 

Denis

[v-yuta-msft]

@Anonymous,

---

So in the last table I have all my costs on production calculated by category. So I have 1 value per category.

I need to calculate each shipment share from total in month by category and that's what I cant do as category's values are in another table.

Here is the final formula of profit I want to get:

$ - $ / Total_$(category) * Money Spent On Production

---

Could you share more details about your formula and give your expected results?

Regards,

Jimmy Tao