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:


      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:



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



      Any help is appreciated and thanks in advance!



      Kind regards,


      Tim P.