2 Replies Latest reply: May 19, 2016 6:36 PM by Ignacio Garribia RSS

    Direct and indirect costs assigment in qlik sense

    Ignacio Garribia

      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