9 Replies Latest reply: Nov 20, 2013 7:36 AM by Theresa Oehler RSS

    Calculate with reference value per dimension - Please HELP!

    Theresa Oehler

      Hello everybody,

       

      I have an urgent problem. Maybe it's simple but I tried so many things and still have no solution.

       

      I have the following table: It is an example but similar to my problem.

       

      Unbenannt.JPG

      Now I want the refernce value to be calculated in the fourth column. The reference value is always the Sales value for the minimum year per region. This means that for the region Asia the refernce value should be 11, for Europe 8 and for the USA 10. But as you can see these values just appear where the year is similar to the minimum year and otherwise appears a zero.

       

      What can I do to receive the reference value per region? The result should like the following table:

       

      Unbenannt.JPG

       

      Thanks in advance for your help.

       

      Best regards.

      Theresa