Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below it data,
Country |
India |
Japan |
China |
India |
India |
Japan |
China |
India |
India |
Japan |
China |
USA |
India |
China |
China |
USA |
India |
Japan |
China |
USA |
India |
USA |
USA |
I am trying to find out ration of each country with total country while loading script, below example
Country | % |
India | 26.1% |
Japan | 34.8% |
China | 17.4% |
USA | 21.7% |
see attached file.
see attached file.
Hi Michele,
Sorry but I can't open this file. Can please paste script here, thanks 🙂
Country_tmp:
LOAD
Country
FROM [Country.xlsx]
(ooxml, embedded labels, table is Foglio1);
Country:
NoConcatenate
Load
Country,
num(count(Country)/NoOfRows('Country_tmp'),'#.##0,0%') as percentage
Resident Country_tmp Group by Country;
drop Table Country_tmp;
Thanks Michele