How to find the Height values of names

[Ramu_i]

Hi All,

I have data 

Country	Revenu
AUS	1000
IND	2000
UK	3000
US	1000
Japan	3000

Requirement 1:  To find the Height values of Country name

Height value is 3000, KPI shows the UK and Japan

Requirement 2: To find the top 2 Values of Country

Top 2 is 3000,2000 here shows the UK,Japan, IND

Thank advance.

Ram

[anat · Accepted solution]

=concat(if(Revenu=max(all Revenu),Country),', ')

[Ramu_i]

Hi Anat,

Thanks for solution, It is working.

Thanks,

Ram

[Ramu_i]

Hi Anat,

This is working fine, 

In that how to find the second height vales names.

First and second heights values of country names how to find this one.

Thanks advance,

Ram