Weighted Average Calculation

[Deepakkumar_A]

Can you assist how to get he D= Sum(B)/Sum(A) = 68.3% in the below table values ?

Month	Category	Actual Rate(A)	Spent(B)	Simple Avg(C)	Weighted Avg(D)
January	Hotel A	$                      1,241	$         654.46	52.7%	52.7%
January	Hotel A	$                         712	$         425.74	59.8%	59.8%
January	Hotel B	$                      2,139	$     1,853.93	86.7%	86.7%
January	Hotel B	$                      2,139	$     1,829.25	85.5%	85.5%
Feburary	Hotel A	$                      2,139	$         980.95	45.9%	45.9%
Feburary	Hotel B	$                      2,139	$     1,767.56	82.6%	82.6%
Feburary	Hotel A	$                      2,139	$         882.24	41.2%	41.2%
Feburary	Hotel B	$                      2,139	$     1,067.32	49.9%	49.9%
March	Hotel A	$                         748	$         542.32	72.5%	72.5%
March	Hotel B	$                         748	$         636.42	85.1%	85.1%
March	Hotel A	$                         748	$         542.32	72.5%	72.5%
March	Hotel B	$                         748	$         579.39	77.5%	77.5%
March	Hotel A	$                         748	$         688.86	92.1%	92.1%
March	Hotel B	$                         748	$         720.07	96.3%	96.3%
		$                   19,274	$         13,171	Avg (C) 71.5%	D= Sum(B)/Sum(A) = 68.3%

[anat]

if u r using qlikview can u try below options:

[Deepakkumar_A]

Hi can you please just in Qlik Sense. Also looking for solution as D= Sum(B)/Sum(A) = 68.3% in the below table values ?