Below it data,
I am trying to find out ration of each country with total country while loading script, below example
see attached file.
Sorry but I can't open this file. Can please paste script here, thanks :-)
(ooxml, embedded labels, table is Foglio1);
num(count(Country)/NoOfRows('Country_tmp'),'#.##0,0%') as percentage
Resident Country_tmp Group by Country;
drop Table Country_tmp;
Retrieving data ...