Value A in % of Value B

[#1]

Dear all,

I am a new QlikView user and came now to a point where I need your help. I have a very easy revenue data model consisting of a view dimensions only. I use a straight table where I display revenue for Scenarion Actual and Scenarion AOP in 2 rows. I want to add a funcition preffered in a 3rd row which is telling me the % of actual compared to plan. Here is how my table looks like.

Scenario EUR
Actual 90
AOP 100

The 3rd (new row) should now display 90%. Alternatively - if it is easier - I can also use a 3rd column...

Can somebody help me?

Many thanks in advance

Rainer

[#2]

Hello Rainer,

take a look at my little exam app. This seemed to me being easier then descriping what to do. The straight table should work as you expect it. Nevertheless I am not quite happy with it, smells to much like a excel derived solution.

Hope this Helps

Roland

[#3]

Thanks Roland. That helped me to solve the problem.

Rainer