Aggregating and Calculating %

[#1]

Hello,

I am new user of Qlikview and am trying to calculate the % for each product based on the following data set.

Type	Account	Product	Units
A	XX	ABC	10
A	XX	DEF	50
A	XX	GHI	72
A	YY	ABC	62
A	YY	DEF	17
A	YY	GHI	46

I need the results to be as follows

Type	Account	Product	%
A	XX	ABC	7.58%
A	XX	DEF	37.88%
A	XX	GHI	54.55%
A	YY	ABC	49.6%
A	YY	DEF	13.6%
A	YY	GHI	36.8%

Please advise on most optimal way of doing this.

Thanks

[marcus_sommer]

Try something like this in a pivot-expression: sum(value) / sum(total <Type, Account> value)

- Marcus

[maxgro]

sum(Units) / sum(TOTAL <Account> Units)