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:
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:
Then I tried to write an expression for percentage of total of each calculation Item and the result was this table:
Any Ideas of how to implement this??
Thanks in advance.
PS. I've attached a Qlikview Sample: