Store a value in a variable using selected value

[jeevays7]

Hi all,

I have a table like this.

Name      Value

A               100

B               150

c                200

If i select a value (i.e. 100) in above table , it will sort like below.

Name     Value

A              100

i don't want to filter like above table and i want to show the name of the value which i select from the table.

[Anil_Babu_Samineni]

What if, data set like below. If you select 100 what are you expecting to see

Name      Value

A               100

A               100

B               150

B               150

c                200

c                200

[asgardd2 · Accepted solution]

Hello! I think, you can do it with triggers.

See the sample in attachment.

[jeevays7]

Thank you anton,

i got the result successfully.