Sum function use in table with reference to other table

[kushalthakral]

Dear all

i am new to qlikview

i have some requirement like below

i have a table

Model	Import	Export	Total
A	0.00	62.78	62.78
B	77.83	35.17	113.00
C	0.00	86.96	86.96
D	0.00	0.90	0.90
E	1.39	0.01	1.40
F	122.35	61.09	183.44
	201.57	246.92	448.49

Requirement is like i have to calculate below expression

x=(33/(B's Total+C's Total)) * B's Import

and

y=(33/(B's Total+C's Total)) * C's Import

and then create a table like

Model	Import	Export	Total
A
B	x
C	y
D
E
F

Thanks in advance

Regards

Kushal Thakral

[kushalthakral]

Also Massimo i am not able to get TOTAL at the bottom.