Dividing two values in different tables
I currently have 2 tables: Sheet 1 and Census data. I have built the census data to show: Census Data Age/Gender = DATATABLE( "Age Group Name",STRING, "Male",INTEGER, "Female",INTEGER, "Total",INTEGER, { {"0-4 yrs",169731,161784,331515}, {"5-14 yrs",344848,330189,675037}, {"15-24 yrs",292492,283960,576452}, {"25-34 yrs",318401,341009,659410}, {"35-44 yrs",368527,378354,746881}, {"45-54 yrs",311036,315009,626045}, {"55-64 yrs",252556,256402,508958}, {"65-74 yrs",184462,189046,373508}, {"75-84 yrs",89313,107191,196504}, {"85+ yrs",23062,44493,67555} } ) What I'm trying to do is take the count per age group in Sheet1 and multiply it by the Total in the census table e.g. first value of 0-4 yrs is 5 therefore (5/331515)*100000 = 1.5 Thanks in advance https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0
