Ratio between two dimensions

[mys-elf]

Hi All,

I want to generate a matrix which shows me the ratio between two dimensions.

First I calculate the revenue by a set analysis. This revenue belongs to the selling profitcenter and also to the profitcenter where the buying customer is allocated.

Every customer is allowed to buy in every profitcenter he wants to and I want to see the ratio between the allocation and the actual distribution of revenues.

It's esy to calculate absolute values (picture/left) but I got some trouble in finding a working formula for the ratio between those two dimensions (picture/right). I think it has to be the AGGR-function but I don't know how to use it the right way.

Thanks in advance!

[Gysbert_Wassenaar]

Generally you want something like sum(Value)/sum(TOTAL Value). Since you didn't post any information about your expression other then that there's an aggr in it somewhere I can't give you a better answer.

[mys-elf]

Ok, that's my formula for the absolut value:

sum({$<t.stat.type={2}>}t.stat.revenue)

And I want something like for the ratio between two dimensions:

sum({$<t.stat.type={2}>}t.stat.revenue) -- 'dimension a'

/

sum({$<t.stat.type={2}>}t.stat.revenue) -- 'dimension b'

[jolivares]

In this case you can use functions like above/below  see in the help how use it them.

[#5 · Accepted solution]

Matthias,

i understand, that customer allocation and selling profitcenter are you two dimensions.

Look for my example.

[mys-elf]

Thank you so much Dariusz!!!