Ratio Contribution

[DipeshVadgama]

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%

[micheledenardi · Accepted solution]

see attached file.

[DipeshVadgama]

Hi Michele,

Sorry but I can't open this file. Can please paste script here, thanks 🙂

[micheledenardi]

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;

[DipeshVadgama]

Thanks Michele