5 Replies Latest reply: Apr 28, 2014 3:08 AM by Matthias Hansemann

# Ratio between two dimensions

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.

• ###### Re: Ratio between two dimensions

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.

• ###### Re: Ratio between two dimensions

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'

• ###### Re: Ratio between two dimensions

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

• ###### Re: Re: Ratio between two dimensions

Matthias,

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

Look for my example.

• ###### Re: Re: Ratio between two dimensions

Thank you so much Dariusz!!!