2 Replies Latest reply: Sep 17, 2018 3:35 AM by Tim Poismans RSS

    Dividing costs

    Tim Poismans

      Hi all

       

      I have the following problem:

       

      We got a customer which has a Head Office and several other offices.

      I need to divide costs booked on the Head Office (Marked in yellow in first picture) between the other offices.

       

      Example of the data:

      TeVerdelenOmzet.PNG

      The data marked in yellow are the costs that I need to divide between the other offices.

      But as my table has the offices as column dimension, I can't seem to get the value of the "Head Office" calculated under any of the other offices.

       

      What it would need to look like is the following:

      TeVerdelenOmzet_Ideal.PNG

       

      Formula for the values is a simple "Sum(Bedrag)".

       

       

      Any help is appreciated and thanks in advance!

       

       

      Kind regards,

       

      Tim P.