problem with grouped values

[paolojolly]

Hi I'm new in Qlikview and I need help to create a pivot table from the follow excel table

C_CLIENTE	D_CANALE_ANAGR	C_LINEA_FAT	W_TOT_KG
C0001299	GD	132	-144
C0001299	GD	005	-140
C0001299	GD	138	-120
C0001299	GD	005	-100
C0002266	GD	132	352
C0002266	GD	016	360
C0002266	GD	138	360
C0002408	GD & DO	022	120
C0002408	GD & DO	132	184
C0002408	GD & DO	132	192
C0002408	GD & DO	016	240

in the pivot table I have to insert as dimension fields C_CLIENTE and D_CANALE_ANAGR and as expressions the value of

sum(W_TOT_KG) for each C_CLIENTE / sum(W_TOT_KG) group for D_CANALE_ANAGR.

For example for C_CLIENTE C0001299 i need to have -504 / 568 = -0,88732

If I select from a list box a single value C_CLIENTE I expect that the value of sum(W_TOT_KG) group for D_CANALE_ANAGR does not change

I attach a sample document

Can someone help me?

thanks

[whiteline]

Hi.

And what is the problem ? You have already done that.

You can combine and use one expression:

sum(W_TOT_KG)/sum(TOTAL <D_CANALE_ANAGR> {$<C_CLIENTE = >}W_TOT_KG)

[Anonymous]

i just checked your formulae for the example data in your post and the results are on par with what you expect. what am i missing?

[paolojolly]

thanks for the reply, I just wanted to know if I have found the best solution

[Anonymous]

yes, that looks good to me.