Dividing costs

[timpoismans]

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.

[stigchel · Accepted solution]

For the Head office Bedrag in other offices column you can probably use  the TOTAL keyword, something like

Sum({<Office={'Head Office'}>}TOTAL bedrag)

Depending on other dimensions you may need to specify which Dimension to take the total from

TOTAL <Dimension>

[timpoismans]

Works llike a charm.

Thanks Piet!