This content has been marked as final. Show 2 replies
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!