Direct and indirect costs assigment in qlik sense

[#1]

Hello everyone! I need to calculate: 1) Margin by client, being:

*Margin= net sales-production cost- indirect costs

*Indirect costs of each year-month must be distributed according to net sales

Could you please teach me how to do that? I couldn't find this in the community. Thank you very much!!!

I`ve created an example to clarify. It'd be very helpfull if you attach a qvd file

Sales: Client,Product, Month, Year, Net Sales

Production Costs Product, Month, Year, Production Cost

Indirect Costs ( administration and indirect sales costs) Concept,Month, Year, Cost

[swuehl · Accepted solution]

Have a look at attached sample QVF.

I've calculated the sales share for each product per month and year, then distributed the indirect costs per share to the products.

[#3]

Hello!! Excellent! I`m really gratefull for your help!! Thank you very much!