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

    Ratio between two dimensions

    Matthias Hansemann

      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!