Need help on calculation below

[Anonymous]

country	Sum of col 1	Max of col 2	Max of col 3 in %	Max of col2 * col3	sum of col1/(Max of col2 *col 3)	sum of col1/max of col2	if avg sum of col1/(Max of col2 *col 3) -sum of col1/(Max of col2 *col 3) >5% then col1/max of col2
Africa	51	-	87%	-
London	994	6,396	87%	5,570	18%	16%
Phoneix	227	3,043	87%	2,650	9%	7%	9%
New York	1,779	8,161	87%	7,107	25%	22%
Grand Total	3051	8161(Max)	87%(Max)	15327(Total)	17.33%(Avg)	45%(Total

I'm not able to achive the last column as in grand total they are calculating the averge of sum & max values. Can anyone help on this pls

[sunny_talwar]

Would you be able to provide a sample to look at this?

[Anonymous]

Last column calculation is based on sum of col1/(Max of col2 *col 3) (6th coulmn in above table)

Eg: 17.33-18 = -0.67 which is not >5 hence null will be displayed

      17.33-9=8.33 which is >5 hence 9% is displayed in last column

Can you pls help to achieve this logic in Qlikview chart.