percentage of total

[#1]

Hi

In my project, I have several calculation types loaded as "Calc" in an inline table. I've written a different expression for
each calculation type except some that are similar, combined into an expression using "Pick()" function.

For example, take these as my calculation types:

Rank;

Group;

Ratio1;

Ratio2;

Ratio3;          

The last three items have the same expression that is the amount in the mentioned ratio. The number of these calculation types may increase in future. So I've written this expression for my table:

Pick(NumMin(3,Calc_ID)
,First Experssion

,Second Experssion

,Sum({<Year={$(=Max(Year))}>}
if(RatioID=Calc_Ratio,Value))
)

Then I tried to write an expression for percentage of total of each calculation Item and the result was this table:

The problem is that I can't seem to get to 100% on total rows, it seems it calculates the percentage for the whole three columns.

Any Ideas of how to implement this??

Thanks in advance.

PS. I've attached a Qlikview Sample: