Top 3 Higher Values

I am attaching a sample form where i have an integer field of 6 questions
integer q2_1 Tata Rallis
integer q2_2 Bayer
integer q2_3 Syngenta
integer q2_4 UPL
integer q2_5 Corteva
integer q2_6 BASF
and my next set of question depends on q2,
select_one q3 q3_1 Tata Rallis
select_one q3 q3_2 Bayer
select_one q3 q3_3 Syngenta
select_one q3 q3_4 UPL
select_one q3 q3_5 Corteva
select_one q3 q3_6 BASF

Now i want only 3 brands for q3 to be displayed only those brand will be displayed which will have top 3 higher values in q2 for the same brand. Rest brands will not be shown. Provide the solution considering unique values in q2 there will be no duplicates.
I had shared this query earlier but the solution provided did not work for me.
aNWGu8ym4Sy2aDjyhzuH9g.xls (19 KB)

Was eagerly waiting for the reply

You seem to have created multiple topics on the same issue. It is easier to respond to a similar issue posted on the forum and you would still get more users to chyme in on the same thread.


1 Like