Highest percentage or top highest value

Question

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

t1t2t3t4comment802.0 3t11582 t1.t2 2  t2    NA

Qiu · Answer

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

0210-Sshasnk.yxmd

Thableaus · Answer

Hi @Sshasnk

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

Cheers,

Solutionpercentage.yxmd