Filter second\another column based on list box values

[Anonymous]

1. First requirement - Require a list box that will display 'Value1, 'Value2' and 'Value3' I should be able to select these values in the list box. How to achieve this in the list box?

2. . On selection of value1, it should filter a column and search for Value1 in that column. Value1 could be part of large text present in this column. Similarly based on Value2 or Value3 selections in the list box it should search for Value1 and Value3 in that column which has large text content. Any rows that has Value1 content in that column should be filtered and data in the straight table and entire application should be filtered to these rows.

How do I link to make these list box selections to filter the second column that has large content based on the selections made in the list box

If possible would like it trigger free as I am not sure it will work on Ajax client. If actions it is fine. As long as the solution works on accesspoint.

Please share the syntax or steps. Even if using if statements it is fine. Please recommend best solution.

Early response appreciated. If only possible attach a file.

Regards

[Anonymous]

Urgently required

[Anil_Babu_Samineni]

Perhaps this?

ValueList('Value1', 'Value2', 'Value3')

In fact, In straight table you need to custom using this

If(ValueList('Value1', 'Value2', 'Value3') = 'Value1', Sum({<..>} Value1),

If(ValueList('Value1', 'Value2', 'Value3') = 'Value2', Sum({<..>} Value2),

If(ValueList('Value1', 'Value2', 'Value3') = 'Value3', Sum({<..>} Value3))))