Highest percentage or top highest value

[Sshasnk]

I have a dataset where I have different percentages and I have to pick:

1. If the column value is greater than 80. I have to pick that column

2. If no column value has greater than 80 I have picked the top 2 

Below is the sample

t1	t2	t3	t4	comment
80	2.0		3	t1
15	8	2		t1.t2
	2			t2
				NA

[Thableaus]

Hi @Sshasnk 

Here's my solution. Let me know what you think.

Cheers,

[Qiu]

@Sshasnk 
Similar approach though.
And I have added some extra test data.