Calculate % based on parameter

[amber2000]

Hello Qlikview wizards,

I'm trying to calculate % based on a parameter.

WH_Cd	Aisle_Desc	Article_CW	Sum_Colli
			370
12	PBL_Traiteur	N	11
12	PBL_Vlees	N	62
12	PBL_Vlees	Y	152
12	PBL_Zuivel	N	145

The result I want is this (the last column represents the percentages):

12	PBL_Vlees	Y	152	41,08
12	PBL_Vlees	N	62	16,76
12	PBL_Zuivel + PBL_Traiteur	N	156	42,16
			370	100

The expression

=Sum({$<[Article_CW] = {"Y"}, [#Colli]>}/ sum({$<[Article] = {"> 99999"}, [WH_Cd] = {"12"}>}[#Colli])

Wont work because I'm deviding two fields with the same result (370/ 370).

I'll attach this example in a qvw so it's easier to follow what I'm trying to accomplish.

Kind regards,

Ambertje

[amber2000]

I managed to calculate the % with the Total function:

=sum({$<[Article] = {"> 99999"}, [WH_Cd] = {"12"}>}[#Colli])/sum(TOTAL([#Colli]))

The only thing that I can't fixe is to join the fields "PBL_Traiteur" and "PBL_Zuivel" together in this expression.

Can Someone please help me with this minor thing (but o so importent to me) please ???

Kind regards,

Ambertje